How many records a database can handle

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
 
D

Douglas J. Steele

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.
 

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

Top