Max # of records in Access 97?

  • Thread starter Thread starter Toan Chau
  • Start date Start date
T

Toan Chau

Hi,

I was wondering if anyone knew the maximum number of
records that Access 97 can handle per table?

Thanks!!
 
Hello Toan Chau,
To see the Access 97 specifications (file size, # of
objects allowed, etc.) Open Access 97, go to Microsoft
Help and search for 'Specifications'. This will answer
you questions.

Hope this helps, Pete
 
I can give you a precise answer. I packed a 97 database with 130,000,000+
sequential long integer records (no indexing) via a simple loop into 1
table. After a couple weeks the DB finally reached its 1 GB size limit and
produced an error message.

I punched out all the punches in a punch-card, too!

Of course, every time an object is added, "max records" decreases so the
real correct answer is "it depends". If you need a table that might contain
a million+ records, consider SQL Server as the back-end.
 
Thanks!!!

-----Original Message-----
Hello Toan Chau,
To see the Access 97 specifications (file size, # of
objects allowed, etc.) Open Access 97, go to Microsoft
Help and search for 'Specifications'. This will answer
you questions.

Hope this helps, Pete

.
Click to expand...
 
Hi,

I was wondering if anyone knew the maximum number of
records that Access 97 can handle per table?

Thanks!!
Click to expand...

There is no specific maximum number; see Specifications in the online
help.

You're limited to 1 GByte in any single .mdb file (and a table cannot
span databases so that's the limit for a table as well).

In practice, the largest in-use Access database I'm aware of has at
least one 20,000,000 row table. A million rows is getting pretty big
for JET, and you should start thinking about client/server.
 
Back
Top