What are the differences between Access and SQL Server?

This is a question we're often asked, so here's a quick summary of the main additional features you'll find in SQL Server 2000/2005:

AutoNumbers are Int fields with an Index
Indexes can be applied at any time, not just on a new table
InStr and Mid become CharIndex and SubStr
You can't refer to a date within # anymore, SQL Server uses '
Lists for IN() can't end in a , anymore
Data isn't written immediately, it's queued
SQL Server can return the Index field within the SQL
You can set-up Stored Procedures to do complex SQL commands and just call them within SQL
You can by-pass the record locking to improve speed
You can alter a table definition while it's still in use

Access also supports a lower number of concurrent connections and does not scale as well as SQL 

2020Media offers Access on Windows Server 2000/3 and Microsoft SQL Server 2000/2005. If you are currently using Access and want to upgrade to SQL2000, SQL2005 , contact us.