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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum record size and maximum number of records 3
Maximum Records in Table - Maximum Size of Database 2
Access Capacity 3
Access 2003 bloating 2
Upsizing and Limit of number of fields 2
Number of Records 3
Linking Access to selected fields in a large external table 1
MS Access cant change the data type ; there is not enough disk space or memory. 4

Back
Top