I.T. Discussion Community!
-Collapse +Expand
Prestwood IT
Search Group:

-Collapse +Expand Prestwood IT Store

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► KBPrestwood I.T.Prestwood Pr...ASPSuite   Print This     
  From the December 2011 Issue of Prestwood eMag
Prestwood IT ASPSuite:
Error 80004005: Operation must use an updateable query.
Posted 16 years ago on 5/17/2003 and updated 12/8/2011
Take Away:

This error is usually a result of folder permissions.


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.


Share a thought or comment...
Write a Comment...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1215A1
Enter key:
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

 KB Article #100244 Counter
Since 4/2/2008
   Contact Us!
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

65 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...

©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech