Access DB Size limits

[JohnLanc]

Can anyone give me an indication of the practical limitations on the size of Access DBs. I am anticipating a DB I am currently working on becoming in the region of 100MB. The machines we run on are pretty good so I am only really concerned about the limits of Access itself.

Any feedback would be welcome.

Regards

John Lancaster

 

[VBslammer]

[tt]
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.

Number of objects in a database 32,768

Modules (including forms and reports with the HasModule property set to True) 1,000

Number of characters in an object name 64

Number of characters in a password 14

Number of characters in a user name or group name 20

Number of concurrent users 255

etc, etc...
[/tt]
You can find more specs in online help by typing "Access Specifications" in the answer wizard tab.


VBSlammer

Unemployed in Houston, Texas