Office 2003 Security Warning;

[jody frazier]

I develop db in Access for my company (around 200 employees). I have
developed quite a few db's in Office XP for several several employees over
the past few years. My company recently just upgrading to Office 2003. So my
existing db's that I developed in Office XP are not being prompted with a
Security Warning asking whether or not the expressions should be blocked or
not. I though that if you choose not to block them the first time you open
the db in 2003, it would remember this and not ask again for that db. My
question is how can I turn off the security warning message when the db is
opening? Please tell me that I don't have to redesign ALL of the hundreds of
db's I have out there that I programmed in XP????

Thanks!

 

[Ofer Cohen]

Select in the menu bar :

Tools > Macro > Security

Set the security to Low

 

[jody frazier]

Thanks! I have already split the db and made the front end into a MDE. Will
I need to reconfigure all this again?

 

[Ofer Cohen]

The set up it's for Access and not for the specific MDB/MDE.

You can do that in different way
Answer given by Jeff Conrad in prev post


Welcome to Access 2003! Here is some info on this subject:
(Watch out for any possible line wrapping on these links)

You can to go Tools, Macro, Security and set it to low.
If the security item isn't on that menu, you may need to reset your menubar.
See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;833219&Product=acc2003

You can also manually add the following Registry keys:
Set registry as follows:

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

If these are just for your use, you can create a self cert on your computer
and digitally sign your databases. More info at
http://www.microsoft.com/resources/documentation/office/2003/all/reskit/en-us/seca02.mspx

Other link to see
http://office.microsoft.com/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033

Frequently asked questions about Access security warnings
http://office.microsoft.com/assista...ID=HA011225981033&CTT=4&Origin=CH010411391033

More info here:
How to configure Jet 4.0 to prevent unsafe functions from running in Access
2003
http://support.microsoft.com/default.aspx?kbid=294698

Still more info here:
http://www.fmsinc.com/free/tips.html#accesstip19

Another link on the subject:
http://www.access.qbuilt.com/html/vba.html#SetMacroSecLvl

 

[jody frazier]

So basically I'll need to change the security setting on EACH person's
computer before running my databases?

Thank you for your help!

 

[Ofer Cohen]

Yes, you'll need to do that, but one of the solutions is to run code when the
MDB is open that set the security setting, so you won't need to go from one
PC to another.