text: operation must use in updateble query? query to update in access this error usually rases when your connection is fetch-only(readonly) in many cases i ot this error .... but the best solution i found is to use recordset for updating tables(instead of using update command on connection object) i write a simle example here ... i hope it can be usefull for you. the firs code is very shorter but some times rases that error  1) myconnection.open "my connection string" myconnection.execute "update mytable set myfield='new value' where myflag='selectionflag'" myconnection.close  2)  myconnection.open "my connection string" myrecordset = new adodb.recordset myrecordset.cursorlocation=aduseclient myrecordset.locktype=adlockoptimistic myrecordset.open "select * from mytable where myflag='selectionflag'" myrecordset!myfield="new value" myrecordset.update myrecordset.close myrecordset=nothing myconnection.close