Link to home
Start Free TrialLog in
Avatar of Rob4077
Rob4077Flag for Australia

asked on

Is it possible to add a Trusted Location in MS Access 2007 Free Runtime version

I have an application that is used by a number of users who don't have MS Access so they are using it with MS Access Free Runtime version. Unfortunately they keep getting the annoying Do You Trust This File message every time it opens the backend and imports data from a spreadsheet. If they have MS Access I fix that by adding the application folder as a trusted directory. Is there any way of doing that, or something similar, with the Free Runtime Version?
Avatar of als315
als315
Flag of Russian Federation image

You can add trusted locations with group policy:
http://technet.microsoft.com/en-us/library/ff400327.aspx#proc2
Avatar of Rob4077

ASKER

Looks like that is for Office 2010,not 2007. Do you know if there is a 2007 equivalent?
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rob4077

ASKER

Thanks for that. It looks to me like that relates to fully licensed versions. Will that work with the royalty free runtime version too?
It is working for runtime also. You can also use this registry add-on:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"VBAWarnings"=dword:00000001
Avatar of Rob4077

ASKER

Thank you very much for confirming that. I really appreciate your assistance.