Maximum capacity of an MDB file?

I have a complicated system that i开发者_运维技巧s pushing data into an MDB file.

The mdb filesize is currently at 40MB.

Did anyone had any experience with larger mdb files and could tell me what is the maximum capacity that it will be still operational? (if it's dead slow at 150mb i don't call that operational).

Thanks!

David already gave an answer for the maximum file size, so I'll address the speed issue.

Size of the DB alone isn't going to be deterministic of speed. 150 MB is nothing for an Access Jet DB. I've run Access MDB files well into the GB range with no noticeable performance issues. However, the larger the individual tables get the more important it will be to implement a good indexing strategy and architect the databases for optimal performance. This is pretty much the case with just about any DB engine, Access Jet included.

Also, the limit for an MDB isn't necessarily the upper limit on the total size of the data you can manage in a single application. With some clever architecture you should be able to split the data into multiple MDB files and link them into your application.

For Access 2003:

2 GB. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.

per this article: http://www.databasezone.com/techdocs/acclimit.html

You can also find the info here: http://office.microsoft.com/en-us/access-help/access-specifications-HP005186808.aspx

150 megabytes is quite reasonable for Access. I ouwld suggest visiting my Access Performance FAQ page.

I have Access databases in the 300 to 500 megabyte range with 20 simultaneous users giving quite reasonable performance.

MS Access data response depends on database size, Linked tables and Hardware. I have used 1 GB MS Access databases with slight glitch when fetching files. Please also remember to run maintenance/compact process regularly to keep the database size trimmed. You can achieve compacting database dynamically using VBA command. But compact requires you to open database in exclusive mode.