Append linked table warning 1

[loydlr]

I have several excel spreadsheets that I append with a query in Access 2003. I went into Options-Edit/Find and unchecked confirm action queries box, but I still get an annoying pop-up informing me that I am about to make changes to data in a linked table.
"You won't be able to undo the changes this action query is about to make to the data in a linked table or tables.
Do you want to run this action query anyway?"
with a "Yes" and "No" button.
Is there any way to prevent this pop up from coming up?
Thanks...

 

[THWatson]

lloydlr
If you are running this from a command button, you can add a line before your append code...
DoCmd.SetWarnings False

And then after your code, add...
DoCmd.SetWarnings True
in order to turn warnings back on for normal operation.

Tom

 

[loydlr]

Thanks Tom..