database size limits

[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

 

[Jeff Conrad]

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.

 

[Patti]

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

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.

 

[Jeff Conrad]

You're welcome Patti, glad to help.
Come back any time.
If you haven't already, add this to your Favorites list:

http://www.mvps.org/access/