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.
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
IN THIS TASK
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
NOTE: If you change the path in Access, you may change properties such as UseRemoteProvider. Start Access. If the Task Pane is not displayed, point to Toolbars on the View menu, and then click Task Pane. In the Task Pane, click More files. Click the arrow in the Files of Type box, and then click Web Pages(*.html;*.htm;*.hta;*.asp). Browse to the data access page, click it, and then click Open. If the field list is not displayed, click Field List on the View Menu. At the top of the field list pane, right-click the Database icon, and then click Connection. 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. Click OK. Quit Access. Click Yes when you are prompted to save the changes. back to the top
Steps to Change the Connection in FrontPage
Start FrontPage. On the File menu, click Open. 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. At the lower left of the window, click the HTML tab. On the Edit menu, click Find. Type data source in the Find What box. Click Find Next to locate Data Source=(path)\(database).mdb. Edit the path to connect to the correct database. Quit FrontPage. Click Yes when you are prompted to save the changes. back to the top
Steps to Change the Connection in NotePad
Start NotePad. On the File menu, click Open. Click the arrow in the Files of Type box, click All Files, and then browse to the data access page. Click the page, and then click Open. On the Edit menu, click Find. Type data source in the Find What box. Click Find Next to locate Data Source=(path)\(database).mdb. Edit the path to connect to the correct database. Quit NotePad. Click Yes when you are prompted to save the changes. back to the top
For additional information about data access pages, click the following article numbers to view the articles in the Microsoft Knowledge Base:
How to deploy data access pages over the Internet
Common data access page deployment Errors
ACC2002: Supported Providers for Data Access Pages
back to the top
inf changing dap correct do i
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
for other considerations.
Article ID: 304324 - Last Review: 01/11/2015 04:20:17 - Revision: 1.0
Applies to Microsoft Access 2002 Standard Edition Keywords: kbnosurvey kbarchive kbhowtomaster KB304324