[AccessD] Queries suddenly not updatable?

jwcolby jwcolby at colbyconsulting.com
Mon May 16 08:45:06 CDT 2011


If you moved them from Access to SQL Server they are going to fail.  You probably want to switch to 
a dao database (currentdb) and use  db.Execute strSQL, dbSeeChanges.  BTW this will allow you to use 
db.recordsaffected to check and/or log results of the updates.

John W. Colby
www.ColbyConsulting.com

On 5/15/2011 12:38 PM, Arthur Fuller wrote:
> 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