autoexec macro, dialog box pops up

I have created a autoexec macro that runs according to a task scheduler.
This 
macro runs a query over a Linked table(linked to sharepoint list). now
when 
this scheduler open the access db, it gives me a dialog box specifying
that 
execution will affect the change in the lnked table(YES OR NO). Because
this 
macro will run on network server, its not possible to click yes all the
time. 
can you please suggest how can I click YES automatically through a macro
or 
this dialog box can be prevented from popping up. It does not come when i
run 
this macro for a query over a normal table. Please help!

-- 
Amod Goyal
IT System Developer
NSK Precision America