How to change the connection string for an Access 2002 data access page

This article has been archived. It is offered "as is" and will no longer be updated.
Summary
This article shows you the proper format for connection strings when you deploy data access pages. The path in the connection string must point to a database that can be seen from the Web server. This article also shows you some connection strings that are not in the proper format. It then shows you how to change the connection strings in Microsoft Access, in Microsoft FrontPage, and in Notepad.

back to the top

Correct Examples of Connection Strings

  • \\OtherServerName\SharedFolder\Database.mdb
  • C:\FullPathToDatabase\Database.mdb
back to the top

Incorrect Examples of Connection Strings

  • http://myserver.com/database.mdb
  • C:\IPAddress\database.mdb
  • Server.MapPath/databases/database.mdb
  • ftp://myFTP.com/database.mdb
back to the top

Steps to Change the Connection in Access

  1. NOTE: If you change the path in Access, you may change properties such as UseRemoteProvider.

  2. Start Access.
  3. If the Task Pane is not displayed, point to Toolbars on the View menu, and then click Task Pane.
  4. In the Task Pane, click More files.
  5. Click the arrow in the Files of Type box, and then click Web Pages(*.html;*.htm;*.hta;*.asp).
  6. Browse to the data access page, click it, and then click Open.
  7. If the field list is not displayed, click Field List on the View Menu.
  8. At the top of the field list pane, right-click the Database icon, and then click Connection.
  9. On the Connection tab, click the Ellipsis button (...) under Select or enter a database name to browse to the correct database. You can also just edit the path to connect to the correct database.
  10. Click OK.
  11. Quit Access. Click Yes when you are prompted to save the changes.
back to the top

Steps to Change the Connection in FrontPage

  1. Start FrontPage.
  2. On the File menu, click Open.
  3. Browse to the data access page, click the data access page, click the arrow next to the Open button, and then click Open in Microsoft FrontPage.
  4. At the lower left of the window, click the HTML tab.
  5. On the Edit menu, click Find.
  6. Type data source in the Find What box.
  7. Click Find Next to locate Data Source=(path)\(database).mdb.
  8. Edit the path to connect to the correct database.
  9. Quit FrontPage. Click Yes when you are prompted to save the changes.
back to the top

Steps to Change the Connection in NotePad

  1. Start NotePad.
  2. On the File menu, click Open.
  3. Click the arrow in the Files of Type box, click All Files, and then browse to the data access page.
  4. Click the page, and then click Open.
  5. On the Edit menu, click Find.
  6. Type data source in the Find What box.
  7. Click Find Next to locate Data Source=(path)\(database).mdb.
  8. Edit the path to connect to the correct database.
  9. Quit NotePad. Click Yes when you are prompted to save the changes.
back to the top


References
For additional information about data access pages, click the following article numbers to view the articles in the Microsoft Knowledge Base:
291783 How to deploy data access pages over the Internet
300699 Common data access page deployment Errors
304521 ACC2002: Supported Providers for Data Access Pages
back to the top
inf changing dap correct do i
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 304324 - Last Review: 01/11/2015 04:20:17 - Revision: 1.0

Microsoft Access 2002 Standard Edition

  • kbnosurvey kbarchive kbhowtomaster KB304324
Feedback