MS Access Maximum File Size?

[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

 

[Guest]

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

 

[Kevin3NF]

Acces 97 was 1gb. 2000 and newer is 2gb

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Albert D. Kallal]

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

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