Comparing MS Access and MS SQL Server 2005

Both MS Access and MS SQL Server are powerful and established databases.  Each has its own particular strengths and weaknesses.  Microsoft Access is a simple and low-cost database solution.  It works best for companies managing a lesser number of concurrent users with a small database.  MS Access, just as the two-tier architecture falls short when applications are more complex with a larger number of concurrent users.  It is important to understand that the limitations of MS Access are due to the Jet database engine.  SQL Server is a better solution for stable efficient system with a larger number of concurrent users.

MS Access Attributes

• • Simple to use
  • Fast application development
  • Easy distribution
  • Support multi-user shared environment
  • Functions well with 25 or less concurrent users

SQL Server Attributes

• • Robust data integrity
• • Scalability
• • Security
• • Manageability
• • Design for use with 25 or more concurrent users

Kform Project Manager 2007 provides on installation SQL Server 2005 Express, the free version of the Microsoft SQL Server 2005 database.  SQL Server Express is built on the same core database engine are the other editions of the SQL Server 2005 product line.  An application developed using SQL Server 2005 Express works with other editions of SQL Server 2005: SQL Server 2005 Workgroup Edition, SQL Server Standard Edition, SQL Server Enterprise Edition