Rob4077
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?
ASKER
Looks like that is for Office 2010,not 2007. Do you know if there is a 2007 equivalent?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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\Softwar e\Microsof t\Office\1 2.0\Access \Security]
"VBAWarnings"=dword:000000 01
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Softwar
"VBAWarnings"=dword:000000
ASKER
Thank you very much for confirming that. I really appreciate your assistance.
http://technet.microsoft.com/en-us/library/ff400327.aspx#proc2