Some of the content in this topic may not be applicable to some languages.
You can connect a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) to a Microsoft SQL Server (Microsoft SQL Server database: A database that consists of tables, views, indexes, stored procedures, functions, and triggers. You can connect your database to SQL Server data by using ODBC or by creating an Access project (*.adp) file.) database. If the Access project is already connected to a Microsoft SQL Server computer, you can change that connection.
Tip In Access 2010, you can publish a database to a SharePoint server that is running Access Services, and then use the database in a browser. Read an article or try Office 2010!
Supported Microsoft SQL Server databases
You can connect an Access project to a Microsoft SQL Server 2000 or SQL Server 2005 database by using Microsoft Access 2000, Access 2002, Access 2003, and Access 2007. However, when you use Access 2000, Access 2002, or Access 2003 to connect to SQL Server 2005, you cannot make design changes to SQL Server objects, and some features of SQL Server 2005 may not work correctly. To obtain full functionality when connecting an Access project to SQL Server 2005, connect by using Access 2007 or later.
Note If you are connecting to a named instance of a SQL Server 2000 or SQL Server 2005 server, your Access project client computer must have Microsoft Data Access Components (MDAC) version 2.71 or later installed. You can install MDAC 2.71 by installing Microsoft SQL Server 2000 Personal Desktop Edition from the \MSDE2000 folder on the Microsoft Office 2003 CD-ROM.
- Open the Access project that you want to connect to a Microsoft SQL Server.
- On the File menu, click Connection. If the Connection menu command is not visible, click the arrows at the bottom of the File menu to display the entire list.
Note The Connection command is available only when an Access project file (a file with an .adp extension) is open.
- On the Connection tab in the Data Link Properties dialog box, enter a server name and the information necessary to log on to the server, and then select the database on the server. For additional information, click Help in the Data Link Properties dialog box.