FP2000: Error Message When You Attempt to Insert a Database Results Region into a FrontPage Web: "Error '80004005' "

When you attempt to insert a database results region into a Microsoft FrontPage Web, you may receive an error message similar to the following:

This behavior can occur when you attempt to use the Database Results Wizard to connect to a Microsoft Access 97 database.

This article describes some of the common steps to take to troubleshoot this error message. It is not necessary to follow these methods in the order in which they are presented.

Test the OLE Connection

Create a sample Active Server Pages (ASP) Web page with an inserted Data Link File (UDL), and create a connection to the sample Northwinds database in order to test the OLE database connection.

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

Verify the Existence of Temporary Folders

Create the drive:\Temp and drive:\Tmp folders if they do not exist (where drive is the drive on which Windows is installed). To do this, follow these steps:

1. On the Web server computer, start Windows Explorer, and then browse to the drive on which Windows is installed.
2. On the File menu, point to New, and then click Folder.
3. Name the folder Temp, and then press ENTER.
4. Right-click the Temp folder, and then click Properties on the shortcut menu that appears.
5. Click the Security tab. Verify that the Everyone group has at least Read and Write permissions to the folder.
6. Follow steps 2 through 5 to create a TMP folder with sufficient access permissions.

For additional information about setting folder permissions in Windows, click the article numbers below to view the articles in the Microsoft Knowledge Base:

Verify the Access Permissions to the Winnt and ADO Folders

Verify that the Everyone group has at least Write and Read permissions to the following folders:

Verify the TEMP and TMP System Variables

Verify that the TEMP and TMP environment variables exist as system variables. To do this, follow these steps:

1. On the Web server computer, click Start, click Settings, click Control Panel, and then double-click the System icon.
2. If your computer is running Microsoft Windows NT, click the Environment tab. If your computer is running Microsoft Windows 2000, click the Advanced tab, and then click Environment Variables.
3. Under System Variables, search for the TEMP and TMP variables. Do one of the following:
   • If these variables exist, verify that the path is correct.
   • If these variables do not exist, click New under System Variables. In the Variable Name box, type TEMP. In the Variable Value box, type c:\temp. Repeat this step to create a name and value for the TMP variable.

Edit Registry Permissions

NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.


Assign Full Control permissions to the Everyone group for the following registry subkey: To do this, follow these steps.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

1. On the Web server computer, click Start, and then click Run.
2. In the Open box, type regedt32, and then click OK.
3. Select the HKEY_LOCAL_MACHINE on Local Machine window.
4. Double-click SOFTWARE, and then click ODBC.
5. On the Security menu, click Permissions.
6. Click Add, click Everyone in the Name list, click Add, click OK, and then click OK again.
7. Quit Registry Editor.

Test Microsoft Data Access Components

Use the Microsoft Component Checker (ComCheck) utility to test the Microsoft Data Access Components (MDAC). To obtain the ComCheck utility, follow these steps:

1. See the following Microsoft Web site:
   http://msdn2.microsoft.com/en-us/data/aa937695.aspx (http://msdn2.microsoft.com/en-us/data/aa937695.aspx)
2. Click MDAC Utility: Component Checker Version 2.7.
3. In the File Download dialog box, click Save this program to disk, and then click OK.
4. In the Save As dialog box, click Desktop in the Save in box, and then click Save.
   
   NOTE: The file name that is listed should be cc.exe.
5. When the download process is complete, click OK.
6. Double-click the self-extracting cc.exe file, and then extract the ComCheck tool to the C:\comcheck folder.
   
   NOTE: To start the ComCheck tool, use the command line, or double-click the ComCheck.exe icon in the C:\Comcheck folder.

For additional information about troubleshooting MDAC, click the article number below to view the article in the Microsoft Knowledge Base:

Reinstall the Jet Database Service Pack

To obtain the latest service pack for Jet 4, visit the following Microsoft Web site:
For additional information about how to identify the Jet database components, click the article number below to view the article in the Microsoft Knowledge Base:

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base: