Max number of recs?

  • Thread starter Thread starter Wei
  • Start date Start date
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
 
Is there a way to link databases together so you can continue with data
entry past this 2 GB point? I know with my database it won't take long
before I reach that data cut-off point.
 
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.
 
Back
Top