From the December 2011 Issue of Prestwood eMag

Prestwood IT ASPSuite: Error 80004005: Operation must use an updateable query. By Mike Prestwood

Posted 21 years ago on 5/17/2003 and updated 12/8/2011 Take Away: This error is usually a result of folder permissions.  Tags: ASPSuite , Error , 80004005 , updateable query KB100244

Q. I'm getting errors on ALL my ASP database write pages.

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/aspsuite/aspsuite.inc, line 330

A. This error is usually a result of folder permissions.

The writable folder is for .MDB database file and all writable configuration files. ALL writable files start with "ps_".

Notes: Determine which path on your webserver is intended for database files. You may need to contact your service provider, and confirm that Access 2000 (version 9.0) is supported. To prevent the DB files from being accessed from a browser, this folder should NOT be browsable.

If you are configuring your own server, create a folder for the DB with all IIS rights disabled, Executed permissions set to "none," grant IUSR account "modify" privileges to the MDB file.

FrontPage Users: To enable Allow files to be browsed permission, Open your Web live with FrontPage. From the Folder List, right-click the data folder. From the drop-down menu, click Properties, then click on Allow files to be browsed and Allow anonymous upload to this directory.

Comments

KB Post Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205. Visit Profile