Microsoft KB Archive/833219

= Menu items are missing after you upgrade from an earlier version of Microsoft Access to Microsoft Office Access 2003 =

Article ID: 833219

Article Last Modified on 7/28/2006

-

APPLIES TO


 * Microsoft Office Access 2003

-



This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you upgrade an earlier version of Microsoft Access to Microsoft Office Access 2003, the following menu items may be missing:
 * The macro Security menu item may be missing.

To determine whether the macro Security menu item is missing, point to Macro on the Tools menu in the Database window.
 * The Object Dependencies menu item may be missing.

To determine whether the Object Dependencies menu item is missing, follow these steps:
 * In the Database window, click Tables under Objects.
 * In the right pane of the Database window, click to select any table.

On the View menu, you may notice that the Object Dependencies menu item is missing.



RESOLUTION
To resolve this problem, use one of the following methods.

Add the macro Security menu item
 Start Access 2003. On the Tools menu, click Customize, and then click the Commands tab. Click Rearrange Commands, and then click Menu Bar. On the Menu Bar drop-down list box, click to select Tools | Macro. Under Controls, click Add.

The Add command dialog box appears. In the Categories box, click Tools. In the Commands box, click Security.</li> Click OK.

The Security menu item appears in the Controls box.</li> Position the Security menu item by using the Move Up button and the Move Down button.

To position the Security menu item in its own group that is between horizontal lines, follow these steps: <ol style="list-style-type: lower-alpha;"> In the Rearrange Commands dialog box, click Security under Controls.</li> Click Modify Selection, and then click Begin a Group.</li> Click the menu item that is located below the Security menu item.</li> Click Modify Selection, and then click Begin a Group.</li></ol> </li> Click Close two times.</li></ol>

Reset the toolbars in Access 2003
Important If you reset the toolbars in Access 2003 to their original settings, you may lose the custom changes that are implemented in the toolbars.
 * 1) Start Access 2003.
 * 2) On the Tools menu, click Customize.
 * 3) On the Toolbars tab, click to select the Menu Bar check box on the Customize dialog box.
 * 4) Click Reset, and then click OK.
 * 5) Click to select the Database check box, click Reset, and then click OK.
 * 6) Click Close.

The missing menu items that are mentioned in the &quot;Symptoms&quot; section are now available.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
The object dependencies feature and the macro security feature are new features in Access 2003. By using the Object Dependencies menu item, you can view information about dependencies between the database objects. By using the macro Security menu item, you can set the security level for macros in Access 2003 to help protect your computer against potentially unsafe Microsoft Visual Basic for Applications (VBA) code.

For additional information about how to change the security level for macros, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/assistance/hp010446101033.aspx

Additional query words: ACC2003 Access2003

Keywords: kbdownload kbbug kbupgrade kbdisplay kbsecurity KB833219

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.