Look up "Access Specifications" in the Help system for details and other
limitations...
There's no limit to the records in a table, only that the file size doesn't
exceed 2 Gigabytes.
No explicit limit on rows; you're limited to 2 GByte in any single
..mdb file. I know of at least one Access application with 30,000,000
rows in its largest table.
In practice, up to a few million rows should be managable with good
database design.
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.
