Max Records in Access

S

sl

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
 
J

John Vinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - (re-) Set a Table Style 2
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Copy previous record into form field 0
Adding data to MS Access from csv file 0
Mail Merge skipping records/sending one at a time 0
Autonumber field in Excel that behaves the same as Access 0
Split form 0
2 Level Record Protection 0

Top