Number of records in a table?

[pgladney]

-- I have a table with 71000 records in it - is there a limit or other concerns over that many records..?

 

[Galaxiom]

There is record no count limit for a table. The limit is the total database size which is 2GB. This is generally in the order of several million records.

71K records is a relatively small table.

Index any fields used in joins or the Where clauses of queries.

 

[gemma-the-husky]

if you are used to excel, where big tables become slow to process, you will find that doesnt happen in access. Obviously REALLY big tables will take time to process, but the time is of an order of magnitude less than excel.

Access is built for handling large data sets. THe thing is to add indexes to fields on which you need to sort or search frequently

 

[The_Doc_Man]

The real limit is: 2 Gb back-end file. In that file, you must consider having a few hundred or maybe a few thousand bytes for the hidden MSys* tables. After that, your limit is based on the size of the records. You can have as many records as will fit in 2Gb, taking into account that if you have a short key field, (i.e. INTEGER as opposed to LONG) you might have a limit imposed by the key's format. Note also that each index you add will take up not less than the size of the key field plus about 8-12 bytes in the index tables per record.

No record can exceed 2048 bytes, so 71,000 records cannot exceed 142,000,000 (rounded) bytes. This is less than the 2GB limit by quite a bit. You should be fine with that data size.