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.
 

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

Is this too many records 5
Different level of users 2
Access Command to run access, open to specific form and specific record 1
Difference in size of actual access database and its backup 0
Merge Identical Databases 5
Call stored procedure in SSMS from Access 2016 doesn't work. 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
'Attaching' or linking a Word / pdf File to a Database Record 1

Back
Top