DoCmd.RunSQL error

[mapat]

hello,

I am getting an error when executing
DoCmd.RunSQL "UPDATE Contacts SET ..."
The error tells me "unapdatable Table."
I already have the file "distxsql.dll" where I am supposed to have it on the computer. Can anyone please tell me why this is happening and how to solve it??

This is weird because it was working perfectly fine when I left the office on Friday, and my boss told me that the computer was rebooted, and now that I am back, it gives that error.

THANK YOU VERY MUCH

 

[RuralGuy]

We may need a little more information. What version of Access? Can you modify the table directly? Do you have any bogus MISSING references? Any OS updates take place recently?

 

[mapat]

ACCESS2007

I separated the tables from the forms
So I have "system_be.accdb" (where the tables are), and "system.accdb" (where forms are). I can directly modify the tables on the back end file (system_be.accdb) but not on the system.accdb file.

No OS updates.

I don't know about the MISSING REFERENCES.
Which reference would belong to this sql problem so I could add it?

thanks

 

[RuralGuy]

I don't know how much help I can be because I do not have ac2007 yet. MISSING references are actually bogus and I'm not sure the problem still exists in ac07 but here's a link that addresses that particular problem. Could you have a permissions problem? Is the BE in the same disk location as the FE?

 

[krc777]

Not sure if this is helpful but I use:
set rst = db.openrecordset ("SELECT...") and it always works fine. Would that work for you?