M
M Skabialka
One of the departments I have created databases for is upgrading to Office
2007 before the end of the year. I tested one of my databases on a machine
in that department that already has Access 2007 but when the database opened
none of the VBA code was available. There was a message in the Message Bar
saying something about security and it gave an option of enabling content,
which allowed the code to run. But this only works for this instance of
opening Access. Every time you open a database it asks the same thing.
I tried going into the trust center to change the macro settings to enable
all macros, pretty much an absolute necessity in a database with multiple
forms and reports called by VBA code, but all of the settings are greyed
out. Obviously someone has decided that for all Office 2007 installations
there will be tight security, but the users rely on these databases for
critical info.
What setting do I need to ask the powers that be to loosen up so users can
use these databases without the nagging security prompt?
Mich
2007 before the end of the year. I tested one of my databases on a machine
in that department that already has Access 2007 but when the database opened
none of the VBA code was available. There was a message in the Message Bar
saying something about security and it gave an option of enabling content,
which allowed the code to run. But this only works for this instance of
opening Access. Every time you open a database it asks the same thing.
I tried going into the trust center to change the macro settings to enable
all macros, pretty much an absolute necessity in a database with multiple
forms and reports called by VBA code, but all of the settings are greyed
out. Obviously someone has decided that for all Office 2007 installations
there will be tight security, but the users rely on these databases for
critical info.
What setting do I need to ask the powers that be to loosen up so users can
use these databases without the nagging security prompt?
Mich