There is no explicit table size limit; a single .mdb file (or .adp
project) is limited to 2 gigabytes, so the combination of all the
objects in a single file cannot exceed that limit.
In practice, if you have over 10,000,000 records in a table you should
be seriously thinking about moving to a client-server database.
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.
