What is the maximum number of records for an Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the maximum number of records that an Access database can hold?
 
Hi.

It's not really the number of records, but the size of these records (and
how the fields are configured) that limits the database. One Access
database could hold one record or millions of records.

If your database is Access 2000, 2002 or 2003, then it can hold 2 GB of
data. If your database is Access 95 or 97, then it can hold 1 GB of data.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
You must log in or register to reply here.

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

Similar Threads

Maximum record size and maximum number of records 3
About Access limits 15
Record-Locking remains open after closing 0
Whats the maximum number of rows Access 2007 can take? 3
Maximum Revisions? 8
Maximum number of records 2
Access 2007 1
File size in Access 2003 3

Back
Top