Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Frequently Asked Questions
 FAQs for Using Snitz with Access
 FAQ: What is Operation Must Use An Updatable Query
 Forum Locked
 Printer Friendly
Author Previous Topic Topic   

heptite
Average Member

USA
547 Posts

Posted - 29 October 2001 :  16:27:26  Show Profile  Visit heptite's Homepage  Send heptite an ICQ Message  Send heptite a Yahoo! Message
Question: What is Operation Must Use An Updatable Query and how can I fix it?

Answer: This problem is normally caused because the directory your Access database is stored in does not have the correct privledges set.

Quoting from the following Microsoft KB article:

http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP

This error is typically encountered when your script attempts to perform an UPDATE or some other action that alters the information in the database. This error occurs because ADO is unable to write to the database for one of the following reasons:

The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.

NOTE: When using Microsoft Access databases with ADO, it is also necessary to give the Internet Guest account Write permissions on the directory containing the .mdb file. This is because Jet creates an .ldb file to handle database locking. You may also need to give read/write permission on the "Temp" folder because Jet may create temporary files in this directory.

Sue
(Former KB Lead for Microsoft Excel)

Additional support files - http://www.snitz.info
<
  Previous Topic Topic   
 Forum Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07