If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 Trust Settings
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! |
#2
|
|||
|
|||
Access 2007 Trust Settings
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. "Del" wrote in message ... 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! |
#3
|
|||
|
|||
Access 2007 Trust Settings
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. Del wrote: 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! -- Please Rate the posting if helps you. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
#4
|
|||
|
|||
Access 2007 Trust Settings
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." AccessVandal wrote: Disabling Macros may not be a good option in your case. But it's possible since the DB is already a trusted application. -- Please Rate the posting if helps you. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
Thread Tools | |
Display Modes | |
|
|