Kbase P1238: Error: Operation Must Use an Updateable Query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Active Server Pages are being used to modify the data in the database.
"Read Only" setting is not checked off in the Options page for the DSN in the ODBC Manager.
SQL statements do not violate referential integrity of the database.
The database is opened with the correct MODE for writing.
Error: Operation Must Use an Updateable Query.
CAUSE:
Typically, the error occurs when your script attempts to perform an UPDATE or some other action that alters the information in the database. It appears because ADO is unable to write to the database because the Internet Guest Account
(IUSR_MACHINE) does not have write permissions on the database file (.mdb).
FIX:
Use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.