Microsoft Office® Access 2007 Inside Out

Exploring a Project File—Conrad Systems Contacts

Microsoft Access 2000 introduced an advanced facility that allows you to create a project file (with an .adp extension) that contains only your forms, reports, macros, and modules. When you create a new project file, you can specify an SQL Server database to support the project. SQL Server stores the tables and queries you use in the application that you design in the project. You can connect your project file to a Microsoft SQL Server version 6.5 database on a server or to a version 7.0 or later database on a server or on your desktop. Included with the 2007 Microsoft Office release is a special edition of SQL Server 2005, the Microsoft SQL Server Desktop Engine (MSDE), that you can install to ...