Access 2007 built-in security

[mikemaki]

Hi everyone-
When we rolled out Access 2003, we changed a registry key to lower the security level on all machines to allow macros to be run. Now, in preparation for a 2007 rollout, we are finding the security level has been raised again. We have hundreds of users and to have each one do this through the Trust Center is out of the question. I believe the 2003 rollout included this statement:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level

Does anyone know how we can change this globally across the network for each client PC?

 

[SOS]

See here:
Access Junkie 2007 FAQ

Which shows what registry settings need to be set and then you should be able to, as admins, run whatever script you would normally do to do registry updates remotely (not sure how you do that as I'm not a network admin).

 

[mikemaki]

Thanks. I'm not an admin either, but my manager wants me to figure this out. I really don't know what I'm doing. But rather than creating a trusted location, we'd like to globally lower the security.

 

[SOS]

Thanks. I'm not an admin either, but my manager wants me to figure this out. I really don't know what I'm doing. But rather than creating a trusted location, we'd like to globally lower the security.

You can't - for Access 2007 you need a trusted location - period. Which means you need to update the computer's registry based on the info I gave in the link. Your network admins should be able to help you with putting together something to update each computer automatically.

 

[mikemaki]

Can a whole drive be defined as a trusted location?

 

[SOS]

Can a whole drive be defined as a trusted location?

It may be able to be, but the Root Drive (where the Operating System is installed) is not likely able to be - so you can't trust the C: drive if Windows is installed there. Some simple testing should allow you to find out - try it. Go to a computer with Access 2007 on it and try to add the C: drive as a trusted location.