techneitsolutions
asked on
access through remote app
Hi,
We have a access database on our TS server. this database can be accessed through remote app.
Now, I am stuck with the security warnings.there are some macros being run at startup and acces keeps throwing following error: macro action 'SetWarnings' cannot be run in disabled mode. when I then click OK, I have a security warning where I can enable the vba macro.
When I run it with the admin account, then everyting is ok but for other users it isnt.
how can I disable these errors (warnings) so that the user opens the access database through remote app without the need to do these actions?
What we already did is through GPO enabling the following settings:
userconfig -> policies -> admin templates -> MS office Access 2007 -> application settings -> security -> trust center -> VBA Macro Warnings Setting enabled with No security checks for macros
and also in the trusted locations I added the path to the access folder.
but still I get the errors
any advice how to disable the warnings?
thx
We have a access database on our TS server. this database can be accessed through remote app.
Now, I am stuck with the security warnings.there are some macros being run at startup and acces keeps throwing following error: macro action 'SetWarnings' cannot be run in disabled mode. when I then click OK, I have a security warning where I can enable the vba macro.
When I run it with the admin account, then everyting is ok but for other users it isnt.
how can I disable these errors (warnings) so that the user opens the access database through remote app without the need to do these actions?
What we already did is through GPO enabling the following settings:
userconfig -> policies -> admin templates -> MS office Access 2007 -> application settings -> security -> trust center -> VBA Macro Warnings Setting enabled with No security checks for macros
and also in the trusted locations I added the path to the access folder.
but still I get the errors
any advice how to disable the warnings?
thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
added this in a bat script and used it with logon script, worked like a charm!
thx