delete and replace table without prompting "confirmation"

[learning_grexcel]

Every time i run the code below, it pops an confirmation whether to delete already existing table.

select * into table1
from query1

I don't want to pop up such a window and automatically it should be replaced when I run the update query.

I already tried unchecking the advanced access option. [record changes], [document deletions], [action queries] but it still pops up the confirmation.

This will be help me to create an autoexec macro and schedule it once a day.

 

[Joe4]

Its the "SetWarning" command you are looking for (one of the "Actions" in "Macros").
Set it to "No".

 

[learning_grexcel]

I tried as below but it was still asking for confirmation
[img=http://s14.postimage.org/yz7lcayxp/autexec_macro.jpg]

 

[Joe4]

I can't see your screen print from my current location (my workplace blocks those images).

Make sure the SetWarning command comes before your RunQuery command.

 

[learning_grexcel]

Thanks joe.

But it's still not working and 'an yellow question' mark appears before Macro name in SetWarnings. Please see my setting is as below
Macro Name >> Action >> Arguments
Autoexec >> SetWarnings >> No
Autoexec >> OpenQuery >> queryname, Datasheet, Edit

 

[Joe4]

Yellow question mark (?), or yellow exclamation mark (!)?
Mine has the exclamation mark, which is normal.

Can you post the full SQL code of your query?
What exactly is the pop-up message saying?

 

[SydneyGeek]

Two things.

One, Set Warnings No needs to be *before* the action query
(And, once finished the delete / append, put Set Warnings Yes)
Two, those exclamations appear in 2007 and above. A range of macro actions are disabled by default. I wrote an article a while back that shows what to do...
http://www.datawright.com.au/access_resources/why_wont_my_macro_run_in_Access_2007.htm

And a third point
Instead of deleting and recreating the table, why not just delete the data and re-append the new? That means that any properties you set for fields in the table will remain.

Denis