Limitation

[Ken]

Does anyone know that there is a record count limitation with ACCESS 2002? Thanks.

 

[Paul Overway]

The limitation is file size....2GB.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

Does anyone know that there is a record count limitation with ACCESS 2002?

Thanks.

 

[Arvin Meyer]

Does anyone know that there is a record count limitation with ACCESS 2002?

Thanks.

No limitation on count, but a 2 GB limitation on size. You can connect to
multiple databases and multiply the 2 GB by the number of databases you
connect to. The practical limit to a single database is actually smaller
than 2 GBs, however the largest I've ever seen was a 30 GB database which
consisted of a front-end and 79 or 80 back-ends of varying sizes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Wayne Morgan]

Not so much the number of records as the disk size of the file.

http://www.databaseconstruction.co.uk/database-capeabilities.htm

--
Wayne Morgan
MS Access MVP

Does anyone know that there is a record count limitation with ACCESS 2002?

Thanks.