GeoffS
Level: VB Lord
Registered: 29-09-2004
Posts: 536
|
Re: MS Access Capacity
Hi,
Max size is 2Gb. per database (mdb file)
Of course if you split the back-end data into a number of mdb files linked into a front-end mdb then you can make it as big as you want as long as each one is less than 2Gb.
Having said all that, if your DB is getting that big then you really should be looking at SQLServer, don't forget that the latest 2005 Express version is FREE to use and re-distribute.
____________________________
multi-tasking - the ability to hang more than one app. at the same time. 
|
