Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why is MS SQL Server better than MS Access?

April 26, 2017MS SQL Server

0

10 Posted

Why is MS SQL Server better than MS Access?

1 Answer

0

10 Posted

Microsoft states that “The Access ODBC Driver and Microsoft OLE DB Provider for Microsoft Jet are not intended to be used with high-stress, high-concurrency, 24×7 server applications, such as web, commerce, transactional, messaging servers ….” Also, “The Microsoft Access ODBC driver can have stability issues due to the version of Visual Basic for Applications that is invoked because the version is not thread safe. As a result, when multiple concurrent users make requests of a Microsoft Access database, unpredictable results may occur.” Because the Access database is on the same server as the web site it tends to use a large amount of resources and this can result in timeouts and database-related errors. The SQL Server can give you unlimited users, 24×7 support, and ACID (Atomicity, Consistency, Isolation, Durability) transactions.