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

Article translations Article translations
Article ID: 304324 - View products that this article applies to.
This article was previously published under Q304324
Expand all | Collapse all

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.

Correct Examples of Connection Strings

  • \\OtherServerName\SharedFolder\Database.mdb
  • C:\FullPathToDatabase\Database.mdb

Incorrect Examples of Connection Strings

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

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.

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.

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.



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

Properties

Article ID: 304324 - Last Review: August 12, 2004 - Revision: 4.0
APPLIES TO
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbhowtomaster KB304324

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com