FPSE2000: Saving Form Results to Access Database ODBC Error

ID: Q234011

The information in this article applies to:

Microsoft FrontPage 2000 Server Extensions
Microsoft Office 2000 Server Extensions

SYMPTOMS

When you save form results to a Microsoft Access database located in a FrontPage Web, the following error message appears:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query

CAUSE

Files that contain FrontPage components (such as the hit counter), require write access in order to function properly. By default, FrontPage allows write access for users with browse permissions on such files.

RESOLUTION

For FrontPage 2000

FrontPage 2000, when used with the FrontPage 2000 Server Extensions, provides a way for users with browse access to update Access database files. For more information, see the following Web site:

Using Databases with Microsoft FrontPage 2000

For FrontPage 98 and Microsoft Visual InterDev 6.0

Using Windows Explorer (or Windows NT Explorer), create a directory outside of your Web content area and store the databases there. For example, if you store all your Web sites in C:\Inetpub\Wwwroot, then you would create a directory called C:\Inetpub\Databases.

Inside the Databases directory, create subfolders for each user. Because FrontPage did not create the Databases folder, FrontPage is not aware of the folder and will not attempt to manipulate the permissions. If your users must be able to get to their databases via the Internet, create an FTP site that points to the directory where the database files are stored.

WORKAROUND

For FrontPage 98 and Visual InterDev 6.0

Create a form using FrontPage.

Set the .mdb file as the target.

Remove the submit button from the form so users don't try to write to it.

An entry will be made in the _vti_pvt/Writeto.cnf file, which informs FrontPage that end users should have write permissions to this file.

WARNING: If you use this method and delete the form or the page containing the form, the database will also be deleted!

Additional query words: front page

Keywords : kbDSupport fpse2000
Version : winnt:
Platform : winnt
Issue type : kbprb