How to disable DoCmd.RunSQL confirmation box?

Given: you have an access database with linked tables to another odbc database (mine is db2)

given2: all sql statement to the database are managed via vba code

problem:

issuing an update, insert, or delete statement via the vba command "DoCmd.RunSQL strSQL"

causes an popup box asking if you are sure you want to "append/insert/delete X records"

I dont want my users to have a choice, the sql statements need to execute without user intervention.

how do i disable this popup and just execute the sql without prompting?

LVL 8
Rance_HallAsked:
Who is Participating?
 
nico5038Commented:
Surround the command by:
docmd.setwarnings false
... command
docmd.setwarnings true

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.