"Franca Petroce" wrote
Can anyone tell me the maximum records
that an access table will hold?
No, no one can give you that information*, because there is no limit on
number of records; the maximum size of a single table is just under 2 GB
because the maximum size of a single database is 2 GB. You can link to
tables in other databases, however, to exceed a total size of 2 GB. There's
a brief article on linking tables at
http://accdevel.tripod.com/linktabl.htm.
* From the fields and their types, you can determine
the storage requirements for the data itself, but
there is some "overhead" for pointers, and the
structure of the database, that Microsoft does not
document, so we can't even calculate an estimate.
Good luck with your project.
Larry Linson
Microsoft Access MVP