Microsoft Office® Access 2007 Inside Out

Installing SQL Server 2005 Express Edition

If you intend to build Access project files (.adp file name extension) that link directly to a database defined in SQL Server, you should install SQL Server 2005 Express Edition on your desktop computer to facilitate building and testing your application. SQL Server 2005 Express Edition is a special version of SQL Server 2005 configured to run on any operating system supported by the 2007 Office release—Windows Vista, Windows XP with Service Pack 2, or Windows Server 2003 with Service Pack 1. With SQL Server 2005 Express Edition installed, you can use an Access project file to create databases and define tables, views, diagrams, and stored procedures that you can later move to SQL Server on a network. ...