In MS Access 2010 I had this query working properly up to we change location of database, we move it on new server. I Re-linked all tables and everything looks ok.
However when user tried to run this query from form command button I got this error.
Query is just updating one table. And it worked before. I checked all references and they ara ok.
Not sure what is happening.
Db.Execute, strSQL, dbSeeChanges
Run-Time Error ‘3073’
Operation must use an updatable query.