There is no limit to the number of records an Access table can hold, as long
as the size of the database itself (MDB file) does not exceed 1 GB for an
Access 97 database or 2 GB for an Access 2000 (or newer version) database.
A 20,000,000 row Table is getting pretty large. 650,000 should be no
problem.
Do note that a Spreadsheet and a Database are TWO VERY DIFFERENT
OBJECTS. Treating Access as a "big version of Excel" will get you into
some *real* design problems!
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.