Access 2003 XP

[Charles]

I am getting the security warning about "Unsafe Expression are not blocked"
when I open a Access DB. I have searched the help files about setting the
security to low, but my problem is that under the TOOL dropdown, I click
macro and there is no option about security as stated in the help files.

What am I doing wrong?

 

[Allen Browne]

Charles, try this sequence:

1. Open Access. If you see the Startup dialog, close it.
2. Right-click the toolbar area, and choose Cusomize.
3. Seledt the Database toolbar (without unchecking it).
4. Click the Reset button, and Ok.
5. Close the Customize box.
6. From the Tools menu, choose Macro | Security.
7. Set to Low.

 

[Mike Wachal]

Charles, try this sequence:

1. Open Access. If you see the Startup dialog, close it.
2. Right-click the toolbar area, and choose Cusomize.
3. Seledt the Database toolbar (without unchecking it).
4. Click the Reset button, and Ok.
5. Close the Customize box.
6. From the Tools menu, choose Macro | Security.
7. Set to Low.

Actually, you need to reset the Menu Bar, not the Database toolbar. You can
also just add the security menu to the menu manually. Both of these
resolutions are documented in the following KB article.

833219 Menu items are missing after you upgrade from an earlier version of
http://support.microsoft.com/?id=833219

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.