Access 2007 Trust Settings

[Del]

The company I work for has just started using MS Office 2007.
I have 100+ MS Access databases that were created with MS Access 2000
- 2003.

One issue I have run into with MS Access 2007 users is when they open
a database that has VB Code or Macros, these items are disabled with
out warning. When this happens none of the buttons or macros will
work.

I have been able to change the Trust Center settings to prevent this
from happening but the settings appear to be per user instead of
global.

Our facility along has 300 users and many of these users share the
same PC. Instead of having to have all users log onto every PC that
they may use to make the changes in the Trust settings.

Is there a way to make these settings globally so we don't have to
make these changes per user?

Thanks!

 

[Klatuu]

It depends on whether users on the same computer are using the same copy of
the file. If all users on a computer use the same file, you only need to
set it up once per computer. If users each have their own copy on the same
computer, you will need to do it for each folder the file is in.

 

[AccessVandal via AccessMonster.com]

If you know what a split database in Access means, you can try out Tony's
AutoUpdater here.
http://www.autofeupdater.com/

If each user have a full version of Access 2007, you'll have to setup Trust
location in each and every one of them. A script may be needed too, if you
want to automate this process.

Disabling Macros may not be a good option in your case. But it's possible
since the DB is already a trusted application.

 

[AccessVandal via AccessMonster.com]

Typos!

Make that "Enable Macros may not be a good option in your case.But it's
possible to enable all macros since the DB is already a trusted application."