Maximum Records

[Amy]

What is the approximate number of records that MS Access
can hold? I am looking for a ballpark figure to make a
determinination if Access is the right tool to use, or if
I should use another.

 

[PC Datasheet]

Access97 has a max file size of 1 Gig; Access2000 and Access2002 have a max file
size of 2 Gig. There is no limit as to the number of records - only the file
size. There have been mention in the newsgroups of Access databases of 1 million
plus records in one of the tables in the database performing satisfactorily.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
..

 

[skd]

True the max file size for an Access file is 2GB. However, since you can
link between Access databases there is no limit to files or records.

Steve