Setting Database Directory Permissions Using Microsoft® FrontPage®

Bookmark-friendly version

When you create a custom database application using FrontPage, the database and the folder that it resides in must have the permissions necessary to access it. If the application just reads data from the database there shouldn't be a problem. But, if the application collects user input to be stored in the database then permissions may become an issue. A common error that occurs when your web application fails to write or update information in the database is the "80004005 Operation must use an updateable query" error. You can correct this by using FrontPage to apply the necessary permissions. Create a form in FrontPage and have it set to post information to the database as follows:

1. Create a new page and add a form element, such as a text box.

2. In Page view, right-click inside the dotted line representing the form and choose "form properties."

3. From the form properties options choose "send to database".

4. Click on the options button at the bottom of the form properties dialog box, then click the button for "New Database".

5. Close the options box and then the form properties box.

FrontPage will restore the necessary permissions that will allow the the database to be written to, fixing the "Updateable Query" error. You can then delete the page if it's not needed.

(Tip courtesy of Bob LaGarde, CEO LaGarde Inc.)

More Resources 

©2002  Microsoft Corporation.  All rights reserved. Terms of Use