Table 1: Differences in Access and SQL Server Limits
Limitation Access SQL Server
Number of characters in a table name 64 30
Number of characters in a column name 64 30
Number of fields in a table 255 250
Table size 1GB 1TB
Database size 1GB 1TB
Number of indexes on a table 32 249 nonclustered plus 1 clustered
Number of fields in an index 10 16 with a maximum combined size of 900 bytes
Number of bytes in a row 2000 1962