MS Access Tutorial: Operation must use an updateable query - Solved

i receive the following error message when trying to save changes i
made to database:


microsoft ole db provider for odbc drivers error '80004005'

[microsoft][odbc microsoft access driver] operation must use an
updateable query.

/tablename_edit.asp, line xxx


answer :

issue

the following error: 80004005 – operation must use an updateable
query – occurs on a page when an event is updating or inserting into
a recordset.

solution

the reason for this (besides occasional mis-designed sql statement)
is, that not all necessary permissions are set. user iusr_<machine
name> has to have permissions:

1. for the directory the access database resides in (right-click on
the directory in explorer, select "properties," "security", if
the "security" tab is missing, go into "tools," "folder options,"
and deactivate "simple file sharing")

2. for the access database itself ("tools", "security", "user and
group permissions")

3. for the odbc source ("start," "control panel," "administrative
tools," "odbc sources", "system dsn", "configure," "options", de-
select read-only)