Results 1 to 8 of 8
  1. #1
    curvehunter is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2017
    Posts
    4

    automate "Client Settings" and "Trusted Location" changes for users

    Hi, I'm about to deploy a simple database to about 100 users. Each user has either their own workstation or a login to a remote server. The database will reside on a network share that each user has read/write permission to.



    What I'd like to do is find a way to automate the setting changes I need to make to each user's Microsoft Access (2010) program. I like to avoid logging into each account or computer and going to Client Settings to uncheck "Record Changes", "Document Deletions" and "Action Queries" and then over to the Trust Center to add the network folder to Trusted Locations.

    Any thoughts?
    Thanks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if it could be automated, that would defeat the purpose of having the security measures to prevent hacking.

  3. #3
    curvehunter is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2017
    Posts
    4
    Quote Originally Posted by ranman256 View Post
    if it could be automated, that would defeat the purpose of having the security measures to prevent hacking.

    Any thoughts on how to make this less of a nightmare?

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You can change Access options by using Application.SetOptions during the database open. Not sure about trusted location, altho the nice thing is they only have to do it once!

    For instance:
    Code:
        Application.SetOption "Confirm Record Changes", False
        Application.SetOption "Confirm Document Deletions", False
        Application.SetOption "Confirm Action Queries", False
    The full list of options can be found here https://msdn.microsoft.com/en-us/vba...m-visual-basic

  5. #5
    curvehunter is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2017
    Posts
    4
    Quote Originally Posted by aytee111 View Post
    You can change Access options by using Application.SetOptions during the database open. Not sure about trusted location, altho the nice thing is they only have to do it once!

    For instance:
    Code:
        Application.SetOption "Confirm Record Changes", False
        Application.SetOption "Confirm Document Deletions", False
        Application.SetOption "Confirm Action Queries", False
    The full list of options can be found here https://msdn.microsoft.com/en-us/vba...m-visual-basic
    That's helpful, thanks. Takes care of a bit part of my issue!
    I just need to find a way to sort out the Trusted Location situation.

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by curvehunter View Post
    Hi, I'm about to deploy a simple database to about 100 users. Each user has either their own workstation or a login to a remote server. The database will reside on a network share that each user has read/write permission to.
    Alarm bells are going off!

    If I understand correctly, you will have 1 database on the server and (up to 100) users will login to that dB?


    You really should have the BE (just the tables) on the server and each user will have a copy of the FE (queries, forms, modules, reports) on their local computer.
    If you don't split the dB, you WILL corrupt your dB..... Not a matter of IF, just WHEN!!


    And with 100 users, you might check into using SQL Server Express as the BE......

  7. #7
    curvehunter is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2017
    Posts
    4
    Quote Originally Posted by ssanfu View Post
    Alarm bells are going off!

    If I understand correctly, you will have 1 database on the server and (up to 100) users will login to that dB?


    You really should have the BE (just the tables) on the server and each user will have a copy of the FE (queries, forms, modules, reports) on their local computer.
    If you don't split the dB, you WILL corrupt your dB..... Not a matter of IF, just WHEN!!


    And with 100 users, you might check into using SQL Server Express as the BE......
    The dB is split- are you saying that I don't need to add the location of the BE to Trusted Locations for each user? That would make me happy.

  8. #8
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Whew... split is good..

    So there are 2 options:
    Best) Set up a trusted location. I created a folder under C:\ named "AccessdBs" that holds all dBs, with subfolders as necessary. A shortcut can be put on the desktop for ease of access to the FEs if necessary.

    Not so good) Put the dB on the desktop or other non- trusted location. When you open the dB, you get a security message about "Active content is disabled". There is a button that enables content. Clicking on the Enable Content button creates a "trusted document".

    See FILE/OPTIONS/Trust Center. Click on the button "Trust Center Settings". Click on "Trusted Documents". READ the warning.

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

Similar Threads

  1. Replies: 3
    Last Post: 07-28-2017, 12:12 PM
  2. Replies: 2
    Last Post: 12-23-2015, 09:32 PM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  5. Replies: 11
    Last Post: 03-29-2012, 02:32 PM

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