record limit?

[Kan D.]

Is there a record limit in a normal table?

for example: 9,999,999 records?

 

[Michel Walsh]

Hi,

None (practically). The file size holding it has a limit of 2Gig, so the
limit will be accordingly to the data stored in that table, and other
objects saved in the save db. A db can span multiple files (with linked
tables).

Hoping it may help,
Vanderghast, Access MVP

 

[John Vinson]

Is there a record limit in a normal table?

for example: 9,999,999 records?

No.

You're limited to 2 GByte in any single .mdb file, and a table cannot
span multiple databases, so you're limited to 2 gigabytes of data -
but there is no explicit limit on the number of records. I know of
Access databases with 20,000,000 rows in the largest table.

See "Specifications" in the online help for all of the limits.

John W. Vinson[MVP]