General discussion

Locked

Limit to records in Access 97

By bjjhome.bt ·
Has anyone any idea of the limit on records in an Access 97 database. The data we have is approx. 1,000,000 records and we need to use this as an archive.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by shiny_topadm In reply to Limit to records in Acces ...

There isn't a specific limit to the number of records (as there is in Excel, for example) but the overall size of an .mdb file cannot exceed 1GB for that version. If each record is very small, this could be room for 2 million entries, or more. Conversely, if each record is large, your data won't fit. Access 2000 changed this limitation to 2GB.

Collapse -

by bjjhome.bt In reply to Limit to records in Acces ...

This question was closed by the author

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums