Show All

Set or change the connection information of a data access page

1. Open the data access page in Design view.
2. On the Edit menu, click Select Page.
3. On the property sheet, click the Data tab.
4. Do one of the following:

   Set or edit the ConnectionString property of the page

   Note  Editing the ConnectionString property of a page that is linked to a connection file will break the link between the page and the connection file.

   • In the ConnectionString property box, either type the new connection string or click the Build button to use the Data Link Properties dialog box to build the connection string.

   Tip

   If you need more room to type the connection string, press SHIFT+F2 to open the Zoom box.

   Specify or change the connection file that the page is linked to

   • In the ConnectionFile property box, either type the name of the new connection file or click the Build button to locate the file.

   Note  Microsoft Access will automatically update the ConnectionString property to reflect the new connection information.

   Edit the connection file of the page

   Note  If the page is linked to a connection file, you can edit the contents of the file. Your edits will affect other pages that are linked to the connection file.

   1. In the ConnectionFile property box, click the Build button .
   2. In the Select Data Source dialog box, right-click the connection file, point to Open With, and click Notepad.
   3. Search for "<odc:ConnectionString>" (without the quotation marks) to locate the connection information and make the changes you want.
   4. Save and close the file.
   5. In the Select Data Source dialog box, click OK.

Notes

• If you have specified a default connection file for new data access pages, Microsoft Access will automatically set the ConnectionFile and ConnectionString properties for a page when you create it.

• This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. For more information about a PivotTable list, spreadsheet, or chart, click Help on that component's toolbar.