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

Advanced
-Collapse +Expand Prestwood IT Store

Prestwood eMagazine

April 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.

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

0 Comments.
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 = P1222A1
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
7113
Since 4/2/2008
Follow PrestwoodBoards on: 


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