How do I make a network folder a trusted location?

[Seth Schrock]

I'm trying to add a network folder to my trusted locations and I keep getting an error message that says, "The path you have entered cannot be used as a Trusted Location for security reasons. Choose another location or a specific folder." The checkbox to allow trusted locations on my network has been checked. I've tried using both the shared drive J:\ and the UNC \\Server Name\folder. I have also tried manually entering the information in the registry. When I do that, it does appear in the trusted locations list, but it is grayed out and I still get security warnings. I'm using Access 2010.

[Mihail]

Hi all !
Seth, I don't know the answer to your question but, if you explain why you need that maybe there are other ideas to accomplish your task.
I say that because I can't see any reason to make a network folder a trusted location. If you use a split database (Front End(s) - Back End), and I am almost sure you do that, the Back End part is located into a network folder (and is no need to be a trusted location but must be a shared folder with permission to modify files) and the Front End part(s) will be located on local folder(s) - (only this folder(s) must be trusted location(s) ).

[Seth Schrock]

I am using a split database. What I'm trying to do is make it easier to update the FE of the database. What I was doing before was to package the solution and then install it on each computer. However, to do it this way required the user to logoff so that a member of IT could logon as an administrator (we attempted to do a runas, but it didn't work for some reason). There are only four users currently, but doing it this way can take about 2-3 hours while waiting for each one to go to lunch. So instead, I have the FE on the server with a shortcut on the desktop of each user. That way I can make the changes, have them get out and then save the changes and they can get back in within five minutes. I actually have two FE files. One I change and then I replace the other one (the one that the users use) when I need to update the program.

[NeoPa]

Why not send the users a command to copy the newest version from the server when required.

TheSmileyCoder has a thread (Email Item as Link from Access) going now which involves the facility to email a user a command to run. In your case, the command would be even simpler and involve just copying a file from the server to a place on the local drive.

[Seth Schrock]

Why not send the users a command to copy the newest version from the server when required.

I think that is what I'll do.

Thanks