What is the max number of rows in a table?

[Guest]

I tried to inserted new rows to a table field, but I got the error 75. I will
like to know the max number of rows that a table can take?

 

[Granny Spitz via AccessMonster.com]

I will
like to know the max number of rows that a table can take?

Depends on how much room you have left in your table. The bigger the rows,
the fewer. The smaller the rows, the more. You can fit up to 1 GB in a
table in Access 2000, 2 GB in Access 2003. Look at Specifications in help.

 

[Rick Brandt]

Depends on how much room you have left in your table. The bigger the
rows, the fewer. The smaller the rows, the more. You can fit up to
1 GB in a table in Access 2000, 2 GB in Access 2003. Look at
Specifications in help.

The 1GB limit was Access 97 and older. Access 2000 has the 2 GB limit.

 

[Granny Spitz via AccessMonster.com]

The 1GB limit was Access 97 and older. Access 2000 has the 2 GB limit.

The question was per *table* not per file. Access 2000 tables can store up
to 1 GB each.

 

[Guest]

Run time error 75 is Path/File access error which I doubt has anything to do
with the number of records in a table.

More than likely you are trying to write to a file where you do not have
write permissions for the database file or file folder.

 

[Rick Brandt]

The question was per *table* not per file. Access 2000 tables can
store up to 1 GB each.

I suspect that the entry you are looking at in the hlep file is a typo.
Surely it is Jet that determines the specs for a table and not "Access" and
since 2000, 2002 and 2003 all use the same version of Jet they should also
have the same specifications.

I have a freshly compacted file on my desktop right now with a single table
in it that is nearly 1.8 GB.