Table Size?

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
 
N

Nikos Yannacopoulos

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
 
Top