A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007 Trust Settings



 
 
Thread Tools Display Modes
  #1  
Old October 28th, 2009, 05:36 PM posted to microsoft.public.access.forms
Del
external usenet poster
 
Posts: 13
Default 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  
Old October 28th, 2009, 06:59 PM posted to microsoft.public.access.forms
Klatuu[_2_]
external usenet poster
 
Posts: 53
Default 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  
Old October 29th, 2009, 02:59 AM posted to microsoft.public.access.forms
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default 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  
Old October 29th, 2009, 03:02 AM posted to microsoft.public.access.forms
AccessVandal via AccessMonster.com
external usenet poster
 
Posts: 461
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.