Access 2003 macro security tab is missing after upgrade from office XP

[gary.l]

I just upgrade from office XP to Office 2003 on a window
XP machine. One new feature in Office 2003 is that the
security setting for Macro is added in Access 2003. I
hope to adjust the macro security level in Access 2003
to "Low" level so the warning message will not show up
each time I open my Access database. But for some
reasons, I can not see the macro security setting, the
security tab in the macro menu is missing. I tried
uninstall office XP completely, then fresh install office
2003 again, still no luck, the Security tab in the Macro
menu still does not show up. But when I installed Office
2003 in another machine with fresh installed windows XP,
the security tab will show up. How do I unhide the
security setting tab from Access 2003?
Thanks
Thanks

 

[Wayne Morgan]

There is a way to get to it. The answer though is on my other computer at
home. If someone else hasn't gotten to you by the time I get home tonight,
I'll look it up and post it.

 

[Wayne Morgan]

Disregard previous message, I found it on this computer as well.

If you want to change macro security and you don't see the Security option
in Tools | Macro, then use these steps:

1. Navigate to View | Toolbars | Customize
2. Click the Toolbars tab.
3. Click Macro Design & Reset.
4. Click Close.
5. Close and restart Access.

Then, you can change the macro security to low (or any other setting via
Tools | Macro | Security).

 

[gary l.]

Thanks for the reply. I tried. It does not work.

Gary

 

[Wayne Morgan]

Well, hopefully the SP will be out very shortly then.

 

[Mike Wachal [MSFT]]

Hi All,

Actually, in step 3 you need to select the Menu bar, not the Macro Design
toolbar. It should work then.

Regards,
Mike Wachal
Microsoft Corporation

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

 

[Wayne Morgan]

Thanks, Mike.

I'll correct my boiler plate.

 

[Wayne Morgan]

Gary,

I just wanted to pass this post on to you in case you didn't get back to the newsgroup.

--------------------------------------------------
Hello Everyone,

I'm sure many of you have discovered this for yourselves already, but I
wanted to make it official. The Jet 4.0 SP8 updates for Windows 2000,
Windows XP and Windows 2003 Server are now available in the Microsoft
Download Center, http://www.microsoft.com/downloads. We will be releasing
the SP8 updates for Windows 9x, Windows NT and Windows Me in the upcoming
weeks. Eventually these updates will also be available in Windows Update
through the typical automatic detection, but for now you can find them by
doing the following:

1. Navigate to the download center at http://www.microsoft.com/downloads.
2. Select the appropriate operating system.
3. Search for "Jet SP8".
4. Click the link to open the download page for Jet 4.0 SP8 on your OS.

When you open the download page, you can select the appropriate language if
it is not automatically selected for you. The direct links to the download
pages for each operating system are:

Windows Server 2003:
http://www.microsoft.com/downloads/...26-5C60-44BC-A2CE-1E40C7FE2B34&displaylang=en
Windows XP:
http://www.microsoft.com/downloads/...C4-350E-4CD0-A12A-D7F70A153156&displaylang=en
Windows 2000:
http://www.microsoft.com/downloads/...39-533E-48B0-B8D7-1781BEFDE1F8&displaylang=en

More information about obtaining the Jet 4.0 SP8 update is available in the
Microsoft Knowledge Base in the following article:
http://support.microsoft.com/default.aspx?scid=kb;[LN];829558.

An Access friendly version of the Jet Sandbox Mode was introduced in Jet 4.0
SP7 and can be used to block unsafe expressions. Information about the
changes to the Jet 4.0 Sandbox Mode are described in the following article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;294698&Product=acc2003.

Access 2003 Specific Information

If you are using Access 2003 and have recently changed you Macro Security
Level to Low in order to eliminate the dialog instructing you to install Jet
4.0 SP8, I urge you to go back and turn on expression blocking now that SP8
is available. You can turn on expression blocking by doing the following:

1. Install Jet 4.0 SP8 using the updates described above.
2. Open Access 2003. You don't need to open a database.
3. On the Tools menu, point to Macros and then click Security.
4. Change your Macro Security setting to Medium and click OK.
5. You will be prompted with a dialog asking if you want to block unsafe
expressions, click Yes.
(Note: This dialog looks very much like the one telling you to install
SP8, but the wording is different.)
6. You will be prompted that you need to restart Access for the setting to
take effect.

When you restart Access 2003, you will not be configured to block unsafe
expressions using the Jet 4.0 Sandbox Mode. When running at a Macro Security
Level of Medium, you will receive a security warning when opening any
database that is either not digitally signed or that is digitally signed by
a publisher that is not trusted. More information is available about the
various Macro Security Levels in help or by reading the topic at
http://office.microsoft.com/assistance/preview.aspx?AssetID=HP010446071033.

If you decide that the Low Macro Security Level is acceptable for your
situation, you can go back to the Security dialog and change you Macro
Security Level again. This time you will be prompted with a question asking
if you would like to allow unsafe expressions to run. I suggest choosing No.
When you choose No, you will be configuring Access 2003 to run under Low
Macro Security, but to continue to block unsafe expressions.

If you have any questions regarding this functionality, feel free to check
out the Access 2003 Assistance Center
(http://office.microsoft.com/assistance/topcategory.aspx?TopLevelCat=CH79001
8001033&CTT=4&Origin=ES790000201033) or to post a question to the
newsgroups.

Regards,
Mike Wachal
Microsoft Corporation

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