 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / August 2004database size limits
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.  SignatureJeff Conrad Access Junkie Bend, Oregon > Is there a limit to the number of records that can be > accumulated in a single database? [quoted text clipped - 4 lines] > TIA, > 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 [quoted text clipped - 18 lines] > >. 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/ SignatureJeff Conrad Access Junkie Bend, Oregon > Thanks, Jeff. That's kind of what I thought, but didn't > know where to find the answer. This newsgroup has been [quoted text clipped - 35 lines] > > > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.