Access records

  • Thread starter Thread starter Nicky
  • Start date Start date
How many records does MS Access 2000 hold?

There's no explicit limit; a single .mdb file can hold up to 2 GBytes.

The largest in-use database that I'm aware of has some 50,000,000
records in the largest table. In practice I'd start looking at a
client-server solution by ten million or so, perhaps more or fewer
depending on the nature of the 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