Database Maximum Capacity

[HGVillanueva]

can anyone tell what is the maximum single database capacity...its actual
size or something...than'x

 

[boblarson]

An Access database (MDB file) has a maximum size of 2 Gigabytes and that
includes system information that is stored in the database, so you have about
1.8 Gb of space.

However, you can use multiple mdb files as backends, even up to using 1 mdb
file for each table.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Guest]

.... even up to using an mdb file for each record ...
....although I expect that you would run into a similar limitation
for each recordset...

(david)

 

[Jeff Boyce]

Open your (version of) Access. Click on HELP. Enter "specifications".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/