How to make it more userfriendly - trust my document
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: How to make it more userfriendly - trust my document

  1. #1
    Board Regular
    Join Date
    Dec 2014
    Posts
    297
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Question How to make it more userfriendly - trust my document

     
    Hi

    My users are quite bad at computers generally.... they dont know what to do and if they see a warning message they panic.

    For example now when i launche my new application for them.
    They get hold up when they start the application.
    They work at different computers so they dont have a personal.

    I would like to make it default that my access files are fully trusted and activated when they start.
    Or at least some simple popups show the first time.

    But as it is now, access show some messages that end up behind the forms that autostart.

    Is there some way to make this process better for the users?

    I have a split database, backend and frontend.
    Have not done anything else with the files.

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    44,475
    Post Thanks / Like
    Mentioned
    29 Post(s)
    Tagged
    4 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

    I would recommend looking into using Trusted Locations. See: https://support.office.com/en-us/art...d-57c6e9a86e02
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    Dec 2014
    Posts
    297
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

    Wont i need to setup trusted locations on each computer we have? Or can i set it up in my files?

  4. #4
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    44,475
    Post Thanks / Like
    Mentioned
    29 Post(s)
    Tagged
    4 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

    Yes, they will need to be set-up on each computer, but it will only be a one-time thing. I would recommend sending out instructions to each user on how to do that, and where they want it set up.

    You cannot "force" it to be done with code. If you could, it would totally defeat the purpose of security, and someone could use it to "force" malicious code to be run on a computer.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  5. #5
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,491
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

    Is this a network environment where each user has their own personal drive and you put a front end for each user in it? In that case, it shouldn't matter what pc they log on to. Their personal folder is trusted across the network. Or are you trying to store fe copies on every pc' C:\ drive that they end up using from one day to the next?
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

  6. #6
    Board Regular
    Join Date
    Dec 2014
    Posts
    297
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

    Quote Originally Posted by Micron View Post
    Is this a network environment where each user has their own personal drive and you put a front end for each user in it? In that case, it shouldn't matter what pc they log on to. Their personal folder is trusted across the network. Or are you trying to store fe copies on every pc' C:\ drive that they end up using from one day to the next?
    It is in a shared network enviroment where each user has their own personal FrontEnd file that they use

    User 1 is named Jenny
    Her file is in 192.168.1.10\sharednetwork$\Application\
    named Jenny
    the next user has its file in the same folder but named with that users name.

  7. #7
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,491
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

    I've never used that schema and don't pretend to be a network guru. Nonetheless, I don't get why you'd have a Trusted Location issue just because they go to a different pc. If 192.168.1.10\sharednetwork$\Application\ is a TL, I would expect it to work from any pc as long as you select the option to extend the setting to all sub folders of that directory. Maybe you didn't create a TL for that location, or didn't extend it to all subfolders of that location. Sorry I can't help more than that.

  8. #8
    Board Regular
    Join Date
    Dec 2014
    Posts
    297
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

    I think you can help.
    Im so new to this that i bet immissing something.


    My network location is the safe place/location. So if i want all my users to be able to open any files on our network.
    I need to setup each Access installation with the settings of trusting our network and subfolders?
    And i can not do this from one place, it needs to be done from every computer in the company?

    Am i correct?

  9. #9
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,491
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to make it more userfriendly - trust my document

      
    I think you can help.
    I will try, but as I said, networking isn't my strong point so some of this is just speculation.
    As a simple example, say you have a server set up like \\ServerName\Department\PersonName and each person can create files and folders under their name as "private". If I create a file with macros or code down in my PersonName tree, that folder has to be a tl. If I make PersonName and all subfolders a tl, any place I put such a file in my own tree should run OK. I'd expect the application to issue a warning about using the subfolder approach as it has in the past for me. This would have to be done either by a network admin from their station, or yes, go around to each user and set it up.

    You seem to have a situation where the fe files exist in \\ServerName\Department\Applications format. If the fe exists in \Applications\MyDatabase\Jenny then I'm saying either \Jenny has to be a tl or MyDatabase has to be a tl with the option set to propagate to all sub folders, the latter seeming the most logical if there's control about the files permitted to exist there under. My expectation is that either way, it would be able to be done once by the network admin and the fe's should work.

    What I admit I don't know is if the setting can work by creating the tl directly on a server or if the setting value has to exist on the pc drive itself. In the latter case, I guess going around to different stations or giving others a Coles Notes version on how to do it themselves is the answer. I have worked on projects that have added keys to the registry via code, so I can't really agree with the statement that it's not possible to do via code. However, it is a skill that can be dangerous in novice hands and I don't advise it. If tl locations are your responsibility, then I suggest you research (Google) trusted locations and see what you find. Otherwise, consult your network admin to see about setting a tl on the server. Another thing that just came to mind on that aspect is whether or not you're using Terminal Services type of network or pc's. I'd think it more possible on a TS network since the user doesn't have a pc anymore.

    P.S - luckily I copied all my answer before trying to save. I got a message from FireFox saying the connection was terminated for security reasons and the answer was gone. So apologies if it gets double posted.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com