database size limits

  • Thread starter Thread starter Patti
  • Start date Start date
P

Patti

Is there a limit to the number of records that can be
accumulated in a single database?

Also, what is meant by a maximum of 32,000 objects in a
database? Does this include records?

TIA,
Patti
 
No limit on the number of records per se, but you are limited to a file size of 1 GB with Access 97
and 2 GB for Access 2000+. However, because your database can include linked tables in other files,
its total size is limited only by available storage capacity.

I've seen posts with Access databases having more than 20 million records, but when you start
getting into that kind of size requirements, it is time to consider something more powerful like SQL
Server or Oracle.

Number of objects limit in an Access database is 32,768. This refers to the total number of tables,
queries, forms, reports, macros, and modules. This has nothing to do with the number of records.
 
Thanks, Jeff. That's kind of what I thought, but didn't
know where to find the answer. This newsgroup has been
so helpful. I have learned a lot just reading other's
questions/responses.
Thanks again!

Patti

-----Original Message-----
No limit on the number of records per se, but you are
Click to expand...
limited to a file size of 1 GB with Access 97
and 2 GB for Access 2000+. However, because your
Click to expand...
database can include linked tables in other files,
its total size is limited only by available storage capacity.

I've seen posts with Access databases having more than
Click to expand...
20 million records, but when you start
getting into that kind of size requirements, it is time
Click to expand...
to consider something more powerful like SQL
Server or Oracle.

Number of objects limit in an Access database is 32,768.
Click to expand...
This refers to the total number of tables,
queries, forms, reports, macros, and modules. This has
Click to expand...
nothing to do with the number of records.
 
Back
Top