Acc2003 - Macro Security

[sheldon]

Hi,

I cannot set the macro security level on one user's
workstation. In Tools menu/macro submenu there is
no "Security" option.

Don't know what happened. Please help. Thanks.

Regards,

Sheldon...

 

[Jeff Conrad]

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

**This is the one that probably is your problem**
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

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

 

[sheldon]

Thanks for you help. I screwed up, though. I thought it
was Access 2003, but its Access 2002. I did notice that 2
files were missing or corrupt (object libraries). I've
asked the local IT guy to reinstall or repair Office XP on
the workstation. Then I will take it from there.

Thanks again.

Regards,

Sheldon...

 

[Jeff Conrad]

Ahh, big difference there.
Definitely sounds like a reinstall is necessary.

 

[Chris Mills]

I thought it

was Access 2003, but its Access 2002.

Ah well, just subtract 1 from all the advice! ;-)