Max Records in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a table with 1.3 million records ( only one field table ). Can
Access 97 holds that much of records?

Thanks.
- sl
 
I need to have a table with 1.3 million records ( only one field table ). Can
Access 97 holds that much of records?
Click to expand...

Yes.

There is no explicit limit on the number of records; the only limit is
the 1 GByte limit on the size of a single .mdb file (all tables,
system tables included, as well as any forms, code, etc.); the
database splitter can help isolate your monster table into a single
database.

1.3 million is quite respectable in size but is well within Access'
capabilities. A one-field table is quite unusual however; how will
this data be used, or searched?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top