Results 1 to 4 of 4
  1. #1
    Stoffman1970 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    2

    Automatically updating the client settings for Confirm actions (Record Changes etc)

    Can someone tell me how I can automatically change the Client settings either with a macro or code. Specifically for the three confirm actions (Record Changes, Document deletions and Action queries). I have a database that is distributed to end users in different offices around the world. The old way lazy way, was to go to each computer and set these settings to "off" manually, but this isn't possible. I want to be able to run delete queries and action queries in the back end without the end users knowing its happening and having to select yes all the time.



    Regards Chris

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Normally I don't like messing with user settings. How about one of these as an alternative?

    http://www.baldyweb.com/SQLWarnings.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Stoffman1970 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    2
    Good idea, thank you very much

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem, and welcome to the site by the way! I should have added that I think you can do it, I just wouldn't personally.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Options, Client settings
    By crowegreg in forum Access
    Replies: 3
    Last Post: 08-10-2012, 10:04 PM
  2. Replies: 1
    Last Post: 07-20-2012, 05:22 PM
  3. Replies: 1
    Last Post: 11-16-2011, 02:29 PM
  4. Automatically updating dates
    By cinciphantom in forum Programming
    Replies: 0
    Last Post: 02-15-2011, 04:33 PM
  5. Automatically updating matrix
    By reuip in forum Access
    Replies: 2
    Last Post: 06-08-2010, 08:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums