How many records a database can handle

  • Thread starter Thread starter shoa
  • Start date Start date
S

shoa

Hello

I have to develop a database for a small agent (for 5-10 users). I am
thinking to use MS Access and VB.net. Could you please tell me how many
records (max) an Access database can handle. Should I choose MS Access, MS
SQL or mySQL (and why?)

Thank you very much for any help

S.Hoa
 
There is no maximum number of records per se. The only limit is that a
single MDB file cannot exceed 2 Gb. You can, however, link databases
together, in which case you're limited by the size of your hard drive.

Depending on your data model, the 2 Gb limit should be able to hold millions
of records.
 
Back
Top