Max number of recs?

W

Wei

You are not limited to the number of records in a table,
however, you are
limited to the total size of the .mdb file. The total
size of the .mdb can
be 2 GB. Performance may decrease a little bit before
this mark. You are
however, limited to 255 field names in a table.

Wei
 
K

Kevin @ 3NF

Sure. Technically, you could put every table in its own database and link
to each one.

Better alternative is to move up to SQL Server if you have that much data
storage. The maintenance of the different databases will get cumbersome
very quickly.
 
Top