How many records a database can handle

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shoa - 21 May 2005 04:45 GMT

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

Reply to this Message

Douglas J. Steele - 21 May 2005 12:37 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello
>
[quoted text clipped - 7 lines]
>
> S.Hoa

Reply to this Message