Access vs MSDE vs SQL Limitations

[Jeff]

Does anyone know the actual limitation thresholds between
Access 2000, MSDE, and SQL 2000? Is the threshold record
number or file size or both?

 

[Douglas J. Steele]

Access 2000 and MSDE each have a 2 GB file size limit, with no record limit.

SQL 2000 has a 1,048,516 TB (yes, terrabyte, not gigabyte!) database size
limit, again with no specific record limit.

 

[Arvin Meyer]

Access 2000 and MSDE each have a 2 GB file size limit, with no record limit.

SQL 2000 has a 1,048,516 TB (yes, terrabyte, not gigabyte!) database size
limit, again with no specific record limit.

By chaining links to multiple (<1GB each) Access backends, the largest
Access database I've seen is approximately 30 GB. Considering that the
largest commercial database I know of is the backup auditing system of the
200 largest retailers in the US. That database is 45 TB. I believe that the
poster will never need the full capacity of SQL 2000.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access