<div>
<div class="content wysiwyg-content">
Given: you have an access database with linked tables to another odbc database (mine is db2)<br />
<br />
given2: all sql statement to the database are managed via vba code<br />
<br />
problem:<br />
<br />
issuing an update, insert, or delete statement via the vba command &quot;DoCmd.RunSQL strSQL&quot;<br />
<br />
causes an popup box asking if you are sure you want to &quot;append/insert/delete X records&quot;<br />
<br />
I dont want my users to have a choice, the sql statements need to execute without user intervention.<br />
<br />
how do i disable this popup and just execute the sql without prompting?<br />
<br />

</div>
</div>


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?



How to disable DoCmd.RunSQL confirmation box?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.