How to disable DoCmd.RunSQL confirmation box?
Posted on 2004-04-12
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
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?