2 rows in Access 2003, but only 1 row in Access 2000. Of course, if your
records are smaller than just under 1 GB each, you'll be able to fit more
records in your table.
There is no explicit limit. A single .mdb file can contain up to two
gigabytes of data.
In practice, if you've got over 10,000,000 rows in your largest table,
you may need to start seriously thinking about SQL/Server or another
client/server architecture. I know of databases with more rows
(carefully designed and maintained), and others with far fewer which
were moved to SQL for performance reasons (requiring substantial
redesign in the process).
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.
