UK Sales: 0800 035 6364 | sales@2020media.com | We'll Call You

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.

2020Media is a leading provider of small business Wi-Fi hotspots. If you want to offer free Wi-Fi to your customers or users, our service could be exactly what you are looking for. Our Hotspots are managed in the cloud, ultra-reliable and give you loads of information about behaviour patterns of your users. Read More   Read more...
2020Media introduces Moodle Hosting - UK servers and UK Moodle experts setup your site ready to use. Read more...
Special Offer for Longer Registration Periods Register or renew a .com, .net or .org domain name for 5 years we'll include 1 year free*. Read more...
2020Media is now offering zero-click installation of the popular TYPO3 content management system. Read more...

Our blog is regularly updated with news, tips and industry opinion.

Clients

  • AggieWestons
  • baker-and-mckenzie
  • arts-council-england
  • Big Finish
  • barratt-developments-logo
  • City-of-Lincoln-council-logo
  • brora-logo
  • DenisMacShane
  • Construction-Industry-Council
  • colchester