White Papers
Create an Access Project
Overview An Access project is an Access file (.adp) that provides a direct, efficient connection to a Microsoft SQL Server database through the OLE DB component architecture. The user can connect an Access project to a remote SQL Server database, a local SQL Server database, or a local installation of the SQL Server Desktop engine. Microsoft Office Access 2007 allows creating new Access project (.adp) files, in addition to working with existing Access projects that is created in earlier versions of Access. This paper provides a brief explanation of Access projects, tells how Access projects work in Office Access 2007, and then tells how to create a new Access project in Access 2007 or connect an Access project to an existing SQL Server database.
| Publisher | Microsoft | File Format | HTML |
|---|---|---|---|
| Date Published | February 2007 | ||
| Format | White Papers | ||
| Topics |
|
||



