Connect a data access page or other Web page to a database

If no database is open when you create a data access page or when you open in Microsoft Access a Web page created outside of Access, Access prompts you for connection information. If you don't specify the connection information when prompted, you'll need to specify it after you've opened the page; otherwise, you won't be able to bind database data to the page. In addition, if you change the location of a database after creating a data access page that stores the original location in its ConnectionString property, you'll need to change the connection information for the page.

1. In Design view of a data access page, display the field list.
   
   
2. Right-click the database icon at the top of the list.
   
   
3. On the shortcut menu, click Connection.
   
   
4. Specify the connection information for the database you want to use for the data access page.

   For information about the Connection dialog box, click the Help button at the bottom of the dialog box.

Notes

• If you already have a Microsoft Access database or Microsoft Access project open when you create a data access page or open a Web page created outside of Microsoft Access, the page is automatically connected to the open database and stores that connection information in its ConnectionString property.
  
  
• You can also change the ConnectionString property in the data access page property sheet directly.
  
  
• A PivotTable list on the data access page may have a separate connection string if it displays data from an external data source. You can modify the connection information for the PivotTable list from within Access by using the Connection Editor in the Data Sources section of the PivotTable Property Toolbox.