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.

What is the difference between the Access and the SQL Server Versions?

April 26, 2017difference SQL Server versions

0

Posted

What is the difference between the Access and the SQL Server Versions?

1 Answer

0

Posted

The MS-SQL version can handle much more users at the same time than the access version. Access database has a size restriction (2GB) and tends to fall when dealing with heavy traffic. Selecting Access versus SQL Server depends on how much traffic you expect to get at your site. Access is not as robust as SQL Server, but easier to use and maintain (cheaper). The MS-SQL version is for high traffic sites, and need an experienced programmer to handle it.