[INSERT INTO & UPDATE] Operation must use an updatable query

[anymal]

The following error happens when I am running the query on my remote site (it does not happen when I am running it on the Access DB or in local mode):
"Operation must use an updatable query"

The queries are:1) INSERT INTO Jobs(job_id, job_name, job_description, year_id) VALUES(65, '201705081s', 'Remota 1', 17)

2) INSERT INTO Requests(job_id, request_user_id, request_status, request_data, request_ora, accept_user_id, accept_data, accept_ora) VALUES(65, 2, 0, '08/05/2017', '9:41:14', 0, '08/05/2017', '9:41:14')

3) UPDATE Requests SET request_status=1, accept_user_id=2, accept_data='08/05/2017', accept_ora='9:48:24' WHERE job_id=64



Can you help me please?

[CJ_London]

if it works in one location but not the other, that implies it is something to do with location. You haven't provided any info on the 'remote site'. Also clarify how these queries are run - ado? dao? etc

[anymal]

Problem solved: it was a problem of permissions

thanks

[Homegrownandy]

Mark as solved - apparently uses can no longer do this?

EDIT: after editing my initial post I can. I don't get these rules. xD