In my VBA code, I have these two statement to call the linked Oracle table (in Access):
DoCmd.RunSQL "Update ... table1"
DoCmd.RunSQL "Update ... table2"
system will pop up a message to ask you to confirm that "the record will be changed".
My question are:
1. how to disable this kind of confirmation message?
2. How to set up transaction in VBA to make sure the two statements are executed together? Any sample code will be appreciated. Thanks.