Jan 5 2011, 09:50 PM
I have an application written with Access version 2007 and installed on a network. All of the workstations are running MS Office v2007.
The application works fine.
Each year we redistribute the application front end to the users.
The majority of workstations have had their desktops made a 'Trusted Location', but it is not unusual for a work station to be re-imaged. Re-imaging leaves the desktop not being a "Trusted" location.
When the user opens the application in a non-Trusted location the results are very confusing to them.
Is there a way that I could trap the event (opening in a non-trusted environment) and show a message?
Graham R Seach
Jan 5 2011, 10:23 PM
No, because the code to do it all is untrusted.
You should not make the desktop a trusted location anway. Is there a reason you don't put it in another location, say c:\Temp\ , and trust that? If you do that, you can get your organisation to modify the image to include a specific location.
Jan 5 2011, 11:41 PM
You could also include in the image a startup script the creates the registry keys to add the trussed location and/or set the macro security level to low.
nother option is to use an lurcher app (EXE) that sets the trusted location before opening the database.
Jan 5 2011, 11:50 PM
s afraid of that.
Thanks for your response.
The reason that we use the desktop is that we are dealing with a large number of people with varying degrees of computer savviness. They do know where the desktop is!
We use certain individuals as helpers for the less savvy and eventually get all work stations working properly.
I was just hoping to find a simple way to alert users when the environment is not trusted.
Jan 5 2011, 11:52 PM
I auto "trust" it at login.
Graham R Seach
Jan 6 2011, 12:25 AM
OK, but you can create a Windows Shortcut on the desktop. Your admins can do that too.
Jan 6 2011, 12:49 AM
Absolutely you can.
In Access 2007 and Access 2010 you can check the status of CurrentProject.IsTrusted using an AutoExec macro (or perhaps in the Load/Open of a startup form). If it's not trusted, then display a message or perhaps a macro-only simple form explaining what the user must do.
For a working example, download and open the Northwind 2007 sample database from a non-trusted location to see how this works.http://office.microsoft.com/en-us/template...=CT101428651033
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.mspx
Jan 6 2011, 09:01 AM
After reading Graham's comment that "No, because the code to do it is untrusted." I slept on the problem.
woke up with this solution..
frmOrder was set as the default opening form.
Ocreated a Splash screen with a label. The label tells the user that they have opened the app in an untrusted location, what to do and whom to contact.
I made the splash screen the default opening form.
In the OnLoad event of the splash screen I put code to close the form and to open frmOrders.
If they open the app in a trusted location the OnLoad code runs bringing them to frmOrders; if they open in an untrusted location then they see the Splash screen.
I appreciate the various other solutions posted since they help me learn more about how access works.
Graham R Seach
Jan 6 2011, 05:28 PM
Sounds like a good solution. border="0" alt="thumbup.gif" />
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here