Maximum Row Number

[Jay]

Hi all,

I was wondering if there is a maximum number of rows in Access 97?

I'm currently parsing a text file and adding the values into a table. The
files are a month summary and could have anywhere from 2,000-25,000 records
(rows) once all the parsing is complete.

I haven't been able to find a listing for a maximum row count. I've found
that the MDB file can't be greater than 1 GB (A97 help) and there's a limit
of 32,768 objects (A97 help). Also, a table can't be larger than 1 GB, but I
can't see how to check the table size.

I've parsed a file with 22,000 records and my MDB file is 5.83MB. I would
take it to mean I've got a lot of space left before I need to worry about
hitting the limit. But it (usually) pays to think ahead.

If anyone can point me in the right direction, I'd appreciate it.

Thanks,
Jay

 

[Rick B]

No, there is no limit to the number of records in a table.

 

[Lynn Trapp]

There is not maximum number of rows in a relational database. You are only
limited by the file size and the size of each row (2000 characters per row).

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[John Vinson]

I was wondering if there is a maximum number of rows in Access 97?

As noted elsethread, no. FWIW the largest Access table in production
use of which I am aware had some 20,000,000 rows (in Access 2.0 a few
years ago). You're not ANYWHERE close.

John W. Vinson[MVP]

 

[Tim Ferguson]

I've parsed a file with 22,000 records and my MDB file is 5.83MB. I
would take it to mean I've got a lot of space left

Yes you do...


Tim F