Add Backend to Trusted - Access Developer Network


	Back to Access Developer Network Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Add Backend to Trusted

Uriel Ramirez

5 years ago

I have a database split in front end and 16 backends which are on a share drive. I have share the front end. The problem that I have is that the front end adds each single table on each back end as a link every time the front end is open. I do not get the annoying open or cancel warning for each back end since I have open and add each back end to the trusted records on the windows registry. However, all the other users get that warning for each table. I do not want them to have open the back ends but I have also not found a way to add the back ends to the registry via VBA. I would like to see if there is a way to get some code that can read the entries on my windows registry, save them to a table and then add the same entries to the other users registry so that they don't get the warning 50 times every time they open the front end.

	Adam Schwanz @Reply 5 years ago
Use GPO (group policy) assuming you have a server, would probably be much easier to add a registry setting.

Scott Axton @Reply

5 years ago

Unfortunately I believe that you will have to add the Trusted Location on each machine.
That is a one time thing but I'm almost positive that there is NOT a way to do it via VBA.
If that were the case it would open up a huge security hole and any one could program it for nefarious activities.

If you can't do it on the users machines an alternative would be to make up an instructions document on how to do it and have each user perform the needed actions in their copy of Access.

I'm unsure of how to address this or how it is handled when using Runtime or an ACCDE copy.

	Bill Olivo @Reply 5 years ago
It does need to be done on each machine. I have used a program named AddPath2010.exe which adds the path to the registry entry. I have used this with several Access DB's and found it to be quite useful. You can Google search for msaccess addpath2010 and msaccess addpath2016, depending on which version of Access you are using.

	Richard Rost @Reply 5 years ago
Thanks, Bill. Yeah, I've always just set up the trusted folder on each machine individually. I've never tried Bill's suggestion, but I would have guessed that there was some tool out there that could do it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Network.

Next Unseen

New Feature: Comment Live View