[AccessD] Queries suddenly not updatable?

Susan Harkins ssharkins at gmail.com
Sun May 15 12:36:16 CDT 2011


Changed anything recently -- anything at all?

<http://www.techrepublic.com/blog/msoffice/when-access-queries-wont-update/578>

You probably know all of the rules I've linked to though.

Susan H.

> I've got some update queries in an app that I run using DoCmd.RunSQL. 
> These
> queries have been working successfully for years, but now suddenly I'm
> getting an error message that says I must use an updatable query. The 
> really
> odd thing is that I recreated one of them and saved it as a named query, 
> and
> it runs fine. I've tried compact and repair without luck.
>
> Has anyone got any idea what may have caused this, and how I can fix it?
>
> TIA,
> Arthur




More information about the AccessD mailing list