error!!! Operation must use an updateable query.

  • Thread starter Thread starter zulu
  • Start date Start date
Z

zulu

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

Why do i get the message above? The system is Windows 2003 server IIS6
I am sure there is read/write permissions for Internet Guest Account user
on db folder and also mdb file!!

Is there any user type (Everyone, guest or
sth other) i must give read/write permissions? or should i give execute
permission? or full control?

what shoul i do?
 
Is this an ASP application? The account IUSR_<machine name> is what needs
the read/write/delete permission on the folder where the MDB file exists.
 
Certain queries are not updatable. This can occur for reasons that are
nothing to do with user or file permissions. It can occur when your query is
structured in certain ways and/or uses certain keywords (eg. DISTINCT). For
example, the following query is non-updatable, regardless of user & file
permissions:

SELECT DISTINCT TheField FROM TheTable;

It sounds like you are using a non-updatable query for some action that
requires an updatable one.

HTH,
TC
 
Back
Top