Maximum Number of records in Database

  • Thread starter Thread starter David
  • Start date Start date
Is there a Maximum recomended number of records for
access ?

No, but there is a maximum total size for an Access database.
Access 97: 1 Gb.
Access 2000 and later: 2 Gb.
The above includes all data, forms, reports, etc.
 
Is there a Maximum recomended number of records for
access ?

There is no explicit limit (see Fred's post for database size limits);
in practice, if you've got over some 10,000,000 records in the largest
table you should be seriously thinking about client-server. The
breakpoint might be higher or lower depending on the specifics of your
application.
 

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.

Ask a Question

Back
Top