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

  • 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

    Tuesday, September 12, 2017 10:37 AM

Answers

  • 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

    Tuesday, September 12, 2017 11:37 AM

All replies

  • 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

    Tuesday, September 12, 2017 11:37 AM
  • Thank you very much Karl!

    Best // Peter Forss Stockholm GMT +1.00

    Tuesday, September 12, 2017 11:39 AM
  • 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.

    Tuesday, September 12, 2017 3:21 PM
  • Thanks Lawrence

    Best // Peter Forss Stockholm GMT +1.00

    Wednesday, September 13, 2017 2:18 PM