How many records is too many?

[Pistol34]

I was wondering how many records does Access 97 and Access 2000 support. I heard that 30,000 records was about it for 97, is this true? Did 2000 increase that number?


Thanks

 

[cdjconsulting]

Very dependent upon RAM, but I have a '97 Access database with a table with 300,000 records. Hums right along.

 

[Terpsfan]

It's not necessarily how many records that limits Access, you have to also consider the number of people accessing the database concurrently. To make the database run efficiently, make sure you declare indexes on fields in the tables that you will often use to look up information. Also most users don't need to pull up all records on a form. For those who just need to enter data, you can set up a data entry screen where only newly added records are shown. A properly-designed Access DB adhering to data normalization can handle over a million records.