When should you use Microsoft SQL Server over Microsoft Access{2}

by Toan T
The article talks about the benefits on when one should choose to use Microsoft SQL Server over Microsoft Access. Microsoft Access is one of the few tools that many businesses use for their database needs. Its intuitive GUI and unique features have made it very easy for people to setup any database and have it running with very little time and efforts. Unfortunately, many large corporations tend to steer away from using Microsoft Access because Access does not have any high level security featureĀ  which makes it very unreliable and hazardous when it come with dealing with sensitive data such as social security numbers, home addresses, etc. This is when SQL server is more preferred because it does exactly what Access can do whist providing many more useful features such as automatic incremental backups, secure data using Windows Active Directory Security System, databases cannot be easily duplicated and so forth. In addition, SQL Server can handle terrabytes worth of data where Access can only handle around 1 gigabyte. Even with the numerous limitations that Access has, it can still be used together with SQL Server One can simply using Access to build a user friendly front end for the database while having all the data be securely stored within SQL Server.

I have worked with Microsoft Access before and is familiar with its features and what it can do but I would still consider myself a newbie when it comes to database. My goal for this class is to learn how to code and design database using SQL as well as learning more about database in general.

Source: Le Roy, Chris. “When Should You Use Microsoft SQL Server Over Microsoft Access? .” WebProNews. N.p., 14 June 2006. Web. 8 Jan. 2012. <http://www.webpronews.com/when-should-you-use-microsoft-sql-server-over-microsoft-access-2006-06>.