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.
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Page numbering with Merged Document and IF statements 1
Maximum record size and maximum number of records 3
Copy previous record into form field 0
MS Access cant change the data type ; there is not enough disk space or memory. 4
File Structure and Performance 5
Autonumber Macro 3
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2

Top