acces maxium rows in table?

M

Mark

Look up "Access Specifications" in the Help system for details and other
limitations...
There's no limit to the records in a table, only that the file size doesn't
exceed 2 Gigabytes.
 
J

John Vinson

On Mon, 21 Mar 2005 09:25:06 -0800, table records rows <table records
What is the maxium number of rows that an access table can store?...
Click to expand...

No explicit limit on rows; you're limited to 2 GByte in any single
..mdb file. I know of at least one Access application with 30,000,000
rows in its largest table.

In practice, up to a few million rows should be managable with good
database design.

John W. Vinson[MVP]
 
Top