 |
|||
|
|||
 |
Microsoft SQL Server vs MS Access Database Selection | ||
 |
|||
Web Site Development |
… a comparison of Microsoft SQL Server and Microsoft Access Microsoft SQL Server is the database server of choice for web application data and for Windows application development whenever data volume is large, multi-user access grows beyond a couple of dozen users or query times need to be highly optimized. Microsoft Access is best suited for desktop use with a small number of users accessing the database simultaneously. People are more likely to have Access on their desktop computer than SQL Server and because MS Access is part of the Microsoft Office suite it is easily installed in almost any corporate environment. MS Access is the more sensible selection when responsibility for ad-hoc reporting and query writing is to be shared by users within the department. We’ve designed and developed many applications that have used one or the other, or even both. There are some practical limitations in the Microsoft Access SQL processor that will impact database design decisions if you want the best performance from MS Access. If in doubt about which product to select you might consider starting with MS Access and upgrading to SQL Server. We can help you select between SQL Server and MS Access and explain the risks associated with each choice and how they are likely to impact your system over time. Further comparison of Access and SQL Server can be found at the following websites:
http://www.quackit.com/microsoft_access/tutorial/microsoft_access_versus_sql_server.cfm The most common MS Access limitations that may limit its effectiveness include: Feel free to contact us for a no-cost consultation to learn how we can help. David Krumholz |
||
|
Copyright 2010, Strand Management Solutions, Inc. All Rights Reserved. Strand Management Solutions, Inc. 61 Princeton Hightstown Road, Princeton Junction, NJ 08550. |