• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1069
  • Last Modified:

URGENT - MSAccess Macro Security in Citrix Environment

Is there a way in a Citrix envirornment to enable macros in MSAccess for all users as the default?

Currently, users are prompted with an option to enable macros or databases that are running VBA code but it's not always apparent to the user what they are supposed to do and they presume there is something wrong with the databases.  

Trying to simplify things for the users as well as myself.
0
rsaphier
Asked:
rsaphier
1 Solution
 
BLipmanCommented:
So there are two issues I have run into: macro security enabled at a level other than Low and a lack of a digital signature.  First, make sure your access files are digitally signed.  Then, what I do (and it only works well when you have a new server or can delete everyone's profiles), is to sign on as a test user, go into access and set Macro Security to Low, sign off, and then copy the NTUser.dat file from the test user to the Default User profile.  Then all new logins inherit the Low macro security.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now