Maximum number of Records

[Pramod Nambiar]

Hi All

Can anybody tell me that what is the maximum number of
records that could be stored in Ms Access 2000 Table?
Presently my application stores 100,000 to 150,000 records
a month which will be transafered to another table at the
end of the month. Now I am enhancing this application and
after that I am expecting an increase in the the number of
records to 500,000 a month. Can Access Support this? or
shall I have to go for SQL Server?
Pls Advice

Thanks & Regards

Pramod

 

[Kevin @ 3NF]

No explicit limit on the number of records, but the file size is 2GB. 500K
records a month is going to get hard to manage pretty quickly. You may want
to plan a move to SQL Server before it gets too far out.

 

[HSalim]

Pramod,
There is no limit on the number of records in an Access table.
However, there is a limit of 1GB/table and 2GB/database in A2K
Performance may not be taht great if you once you cross 1GB database size.
Linked tables are not covered by this restriction, so you may be better off
using the Access db for monthly transactions and archiving the rest of the
data in SQL server.
You can then link to the archive table, and run any queries on the archive
as if it was stored locally in Access.

HS