Insert into Linked table Query that won't excute in code

[CJwater]

Hi!
I'm converting an app that had internal Access tables to SQL tables. I'm having a problem with an "Insert Into" query that inserts into a new SQL table.
I added public permissions on the table for everything. When I run the code in debug mode and leave the query open, I see the query results but it won't actually update the table unless I manually hit the red exclation mark inside the query window. Only then does SQL table get updated.
I have DoCmd.SetWarnings True but when I run the code (DoCmd.OpenQuery "qrya_SaveWorksheet")it does not ask me if I want to append the table. Is there a setting or command I'm missing to run a query on a linked table?

Thanks
CJ

 

[CJwater]

Just in case someone else has the same problem...

I changed DoCmd.SetWarnings from "True" (I usually only use true for debugging) to "False" and it does executed the insert into the SQL table.

 

[genomon]

Don't forget to reset back to True after the code executes.

Ever notice how fast Windows runs? Me neither.