MS Access Maximum File Size?

  • Thread starter Thread starter HMJ
  • Start date Start date
H

HMJ

Does anyone know if thee is a maximum size that an MDB
file can be before MS Access 2000 stops working.

Currently we have a backend that is 850MB in size, and I
had heard somewhere that MS Access 2000 could only handle
a 1GB MDB file. If this is so, we are going to be in a
hurt soon.

THANKS
 
Max size for any mdb file is 2 gigs

If you have split your databse into a front end/back end, you can have multiple back ends holding your tables linked to the front end, extending the amount of data you can hold
Rosc
----- HMJ wrote: ----

Does anyone know if thee is a maximum size that an MDB
file can be before MS Access 2000 stops working

Currently we have a backend that is 850MB in size, and I
had heard somewhere that MS Access 2000 could only handle
a 1GB MDB file. If this is so, we are going to be in a
hurt soon

THANK
 
HMJ said:
Does anyone know if thee is a maximum size that an MDB
file can be before MS Access 2000 stops working.

Currently we have a backend that is 850MB in size, and I
had heard somewhere that MS Access 2000 could only handle
a 1GB MDB file. If this is so, we are going to be in a
hurt soon.

THANKS
Click to expand...

That is getting very large indeed. Is that size AFTER you compact the back
end?
 
Back
Top