Access looks for Confirmation

[sathsaj]

Hi All,

Access looks for confirmation to delete existing data before a query is run. This is a Maketable Query. the Action Queries under Client Setting is unchecked. But still why do we get this message ?

Is there a way were can get this away ?

 

[JHB]

If you run it from VBA code, look at the DoCmd.SetWarnings
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.setwarnings
Or CurrentDB execute query.

 

[isladogs]

If you switch off SetWarnings there is a risk that errors will occur without your knowledge.

As JHB mentioned, the alternative approach is to use CurrentDB.Execute but you should include the argument dbFailOnError so a message appears if a problem occurs

 

[sathsaj]

unfortunately Iam not familiar with VBA

 

[JHB]

How do you run/open the query now?

 

[sathsaj]

I have a macro which is provided by access

 

[Gasman]

I have a macro which is provided by access

If it is really a macro you can add SetWarnings Off prior to the macro and On afterwards.?

 

[sathsaj]

If it is really a macro you can add SetWarnings Off prior to the macro and On afterwards.?

that works