Access Limitations



Is there a limitation on how many records you can have in
1 access table?




Albert D. Kallal

There is not a real limit (I think it is in the billions of records).

However, there is a limit on the size of the database. Thus, you will reach
the database size limit before you reach the record limit.

If you records are small, then you will be able to enter more records. If
you records are large, then you will reach the size limit sooner (but this
is not a record limit!).

The max database size is 2 gigs in a2000 and later. You will find in
practice that you will reach the limits of performances and usability LONG
BEFORE you reach the specified record and database size that ms-access has.

So, you can easily have 1 million address records in a single table and not
be anywhere near the limits of ms-access.

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

Access Limits? 2
Limited access to Access 1
Access Limitations? 4
Limitations of access 11
Access limitations/suitablity 12
Sort limit in Access 4
Access Database size limitations 4
Limiting access to a command button 1