Access Runtime asks to confirm update queries. How turn it off?

Question

Hi

I run an Access app 32 bit. In Access I turned all confirmation off on update queries.

When I, on a Microsoft Virtual Machine, run the same database on a Runtime 2016 installation, the user is promted to confirm every update query.

How do I solve this issue?

---

Best // Peter Forss Stockholm GMT +1.00

Answer 1

Hi,

You could turn off the confirmations using VBA code on startup  of the application, i.e. call the code at open/load of the start form or in an autoexec macro:

Application.SetOption "Confirm Action Queries", False

Personally I don't change the overall option but use the DAO.Execute method to run update queries. This doesn't prompt the Access confirmations in the first place. Another method is to use

DoCmd.SetWarnings False/True

before and after executing an action query with OpenQuery etc.

---

Karl
http://www.AccessDevCon.com
http://www.donkarl.com

Answer 2

Thank you very much Karl!

---

Best // Peter Forss Stockholm GMT +1.00

Answer 3

You can put the following code line in the BeforeDelConfirm Event for each form.

Response = acDataErrContinue

It turns off the confirmation of deleted records in Runtime mode.

Answer 4

Thanks Lawrence

---

Best // Peter Forss Stockholm GMT +1.00