Please feel free to post a complete question using the large blank space
provided.
The built-in help feature can tell you all the limits for your version of
Access. Simply go to "help" and type in "specification". Note that Access
does not have a limit to the number of records a table may contain. The
only real limit there is the overall size of the database file.
No explicit limit - you can have up to two gigabytes in a single .mdb
file.
In practice, I've seen tables with 20,000,000 rows in production use.
John W. Vinson[MVP]
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.