Create a connection file

Microsoft Office Access 2003

Create a connection file

If you want to create a connection file to link to a page that does not exist, follow the procedure for creating a data access page. Use the following procedure if you want to create a connection file to link to an existing page.

  1. If a database is open in Microsoft Access, close it.
  2. On the File menu, click New.
  3. In the New File dialog box, click Blank Data Access Page.
  4. In the Select Data Source dialog box, click New Source.
  5. In the Data Connection Wizard dialog box, select the data source that you want to connect to.
  6. Follow the directions in the wizard dialog box.

    Access creates a connection file with the information you specified.

  7. In the Select Data Source dialog box, click Cancel.

    Access creates a blank data access page.

  8. Close the data access page.

    You can use the connection file with existing or new data access pages.