Automate question answers in make-table query

G

Guest

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,
 
G

Guest

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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make-table 1
Make-table query with around 2 ml records taking too long 0
Automating Macro Responses 5
Make table query: [Enter 1] AS Test 1
Queries & table locking 4
Schedule Auto run Query on append table 0
Make Table Query Popups 9
Append Query Issue 0

Top