I am getting this error when a macro runs which is trying to update an Access table. (see attached). Runtime Error 3320
The statement that is failing is:
UPDATE tbl_Standard_Report a IN 'Directory\my.mdb'
SET a.LastGenerated= #2/25/2014 10:28:33 AM#, a.Duration='00:00:41', a.LastGeneratedBy='usernam
Does anyone see what is wrong. I am running someone else's code. I did notice that the high level qualifier a is not assigned to a table. I don't know if that could be the problem.