Home>Knowledge Base>Web Hosting>Databases>Performance problems with MS Access.
Information
Article ID19
Created On10/6/2008
Modified10/6/2008
Performance problems with MS Access.
While it's possible to use MS Access within your ASP or ASP.NET application we highly recommend the use of MS SQL. MS Access was designed as a single user desktop database. Access is not designed for simultaneous transactions and does not handle writes well.

In the readme.htm file that is included with IIS Microsoft has the following to say:

"For performance and reliability reasons, we strongly recommend the use of Microsoft SQL Server for the deployment of production-quality Web applications." .... "Microsoft Access was designed as a single-user desktop database, and not for server use."


Microsoft makes an excellent, and free, tool for migrating a MS Access Database to MS SQL, The SQL Server Migration Assistant. Please see, http://www.microsoft.com/sql/solutions/migration/default.mspx , for further information.