Maximum Records

[Brown]

Is there a reference that indicates the maximum number of records that
can/should be saved in a table?
I have a requirement for a database that will have a key table containing
over 5000 records and several related fields that will have several records
per record in the key table.

Brown

 

[Arvin Meyer]

No maximum number of records, only maximum database size (2 GB)

I have a table with 143,00 records with a subtable containing over 1,000,000
records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Brown,

Check 'specifications' in ACCESS Help. This will show you exactly how many tables, forms report etc you can have in any mdb.

Jhn Parkinson

 

[John Vinson]

Is there a reference that indicates the maximum number of records that
can/should be saved in a table?
I have a requirement for a database that will have a key table containing
over 5000 records and several related fields that will have several records
per record in the key table.

<chuckle> 5000 records is very modest. 5,000,000 records is getting
pretty big. You're in good shape.