Link to home
Start Free TrialLog in
Avatar of techneitsolutions
techneitsolutionsFlag for Belgium

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

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 techneitsolutions

ASKER

thx als315

added this in a bat script and used it with logon script, worked like a charm!

thx