G
Guest
Does anyone know that there is a record count limitation with ACCESS 2002? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul Overway
The limitation is file size....2GB.
--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com
--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com
Thanks.Ken said:Does anyone know that there is a record count limitation with ACCESS 2002?
A
Arvin Meyer
Thanks.Ken said:Does anyone know that there is a record count limitation with ACCESS 2002?
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
W
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
http://www.databaseconstruction.co.uk/database-capeabilities.htm
--
Wayne Morgan
MS Access MVP
Thanks.Ken said:Does anyone know that there is a record count limitation with ACCESS 2002?