Data storage

  • Thread starter Thread starter Guest
  • Start date Start date
Check Access HELP for "specifications" for your copy of Access.

Depending on version, an Access .mdb file has been limited to either 1Gb or
2Gb.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
how many data files can be stored in access before it crashes

None. Access doesn't store "data files".

The capacity of an Access database (A2000 and later) is 2 GByte, including all
tables, forms, reports and other objects. There is no explicit limit on the
number of records in a table; I'm aware of production databases with tables
exceeding 20,000,000 records.

John W. Vinson [MVP]
 

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