Automate question answers in make-table query

S

stickandrock

I have a scheduled task (windows xp) to run a macro that runs a make table
query at a specific time during the night. The problem is that the query
stops when it ask to insert the rows (Normal procedure for a make table). Is
there a way to automate that answer to be YES or to have the query not ask
the question in the first place.

Thanks,
 
N

NetworkTrade

go to Tools
Options
Edit/Find

in the upper right of this space you will find the Confirm options....try
unchecking these and see if this works....
 
Top