Max # of records in Access 97?

[Toan Chau]

Hi,

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

Thanks!!

 

[Wayne Morgan]

http://www.databaseconstruction.co.uk/database-capeabilities.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;97520&Product=acc97

For the most part, it's not the number of records, but the size.

 

[Pete Sheridan]

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

 

[Rolls]

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.

 

[Toan Chau]

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

.

 

[Toan Chau]

Thanks you sir!

-----Original Message-----
http://www.databaseconstruction.co.uk/database- capeabilities.htm
us;97520&Product=acc97

For the most part, it's not the number of records, but the size.

--
Wayne Morgan
Microsoft Access MVP





.
T

 

[John Vinson]

Hi,

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

Thanks!!

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.