Table Size?

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hi,

I have a big table in access, but after a little more than 4 millions
records I can not include anymore records (access do not allow me to include
an additional record).
Is there a limit in the number of records for an access table?.
Does the limit depend in my Hardware (RAM,...)?.
What about using SQL Server?, I expect my DB to grow till more than 20
millions records.

Thanks,

James
 
James,

There is no limit to the number of records per se; the limit is the
overall .mdb file size, <=2GB. Are you close? Have you compacted lately?
If you are close after a compaction then yes, you need to consider SQL
Server (or MySQL which I hear is a very good alternative, and it is free!).

HTH,
Nikos
 
You must log in or register to reply here.

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

What are the Access 2007 record table limits? 2
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Access Table 5
count number of data in one database in a range from another file? 6
Maximum record size and maximum number of records 3
delete does not reduce the file size 1
Record limit CSV import and more - Access 2002 SP3 1
AutoNumber Field Limits - NOT "How do I reset?" 11

Back
Top