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