Show All

Connect an Access project to a Microsoft SQL Server database (ADP)

Some of the content in this topic may not be applicable to some languages.

You can connect a Microsoft Access project to a Microsoft SQL Server database. If the Access project is already connected to a Microsoft SQL Server, you can change that connection.

1. Open the Access project that you want to connect to a Microsoft SQL Server.
2. On the File menu, click Connection.
3. 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.