Access vs MSDE vs SQL Limitations

J

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?
 
D

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.
 
A

Arvin Meyer

Douglas J. Steele said:
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.
Click to expand...

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
 
Top