Compact And Repair Menu Option MISSING

[Mark G. King]

I have Access 2003 SP2.

When I open any database annd choose Tools / Database Utilities the menu
item Compact And Repair is missing.
I have re-installed Office 2003 using Detect and Repair but this hasn't
helped.

I have other versions of Office loaded on my machine including Access 97,
Access 2000, Access 2002 and Access 2003.

In all other versions of Access the menu item is available but with Access
2003 it's just not there! Any ideas?

View screenshot here:

http://img175.imageshack.us/img175/3725/accessmenuqb8.jpg

- Thanks in Advance

- Mark

[RoyVidar]

Re: Compact And Repair Menu Option MISSING

"Mark G. King" <markgking_Spam Trap@hotmail.co mwrote in message
<eyLNg.28061$rP 1.10017@news-server.bigpond. net.au>:

I have Access 2003 SP2.
>
When I open any database annd choose Tools / Database Utilities the
menu item Compact And Repair is missing.
I have re-installed Office 2003 using Detect and Repair but this
hasn't helped.
>
I have other versions of Office loaded on my machine including Access
97, Access 2000, Access 2002 and Access 2003.
>
In all other versions of Access the menu item is available but with
Access 2003 it's just not there! Any ideas?
>
View screenshot here:

http://img175.imageshack.us/img175/3725/accessmenuqb8.jpg

>
- Thanks in Advance
>
- Mark

I would try to reset the menu bar.

Right click a menu bar, select customize. In the Toolbars tab, select
menu bar, and hit reset.

If this doesn't work, then I don't know, I'm afraid.

--
Roy-Vidar

[Mark G. King]

Re: Compact And Repair Menu Option MISSING

Thanks Roy,

Your suggested pointed me in the right direction. I had to choose the
COMMAND tab not the Toolbars tab choose TOOLS and COMPACT & REPAIR then drag
it to the Access menu bar and drop it. This suggests that I must have
accidentally dragged it off the menu bar at some point.

Works fine now. Thanks again for your help.

- Mark


"RoyVidar" <roy_vidarNOSPA M@yahoo.nowrote in message
news:mn.6a1f7d6 9bd7589e4.59509 @yahoo.no...

"Mark G. King" <markgking_Spam Trap@hotmail.co mwrote in message
<eyLNg.28061$rP 1.10017@news-server.bigpond. net.au>:

>I have Access 2003 SP2.
>>
>When I open any database annd choose Tools / Database Utilities the menu
>item Compact And Repair is missing.
>I have re-installed Office 2003 using Detect and Repair but this hasn't
>helped.
>>
>I have other versions of Office loaded on my machine including Access 97,
>Access 2000, Access 2002 and Access 2003.
>>
>In all other versions of Access the menu item is available but with
>Access 2003 it's just not there! Any ideas?
>>
>View screenshot here:
>http://img175.imageshack.us/img175/3...essmenuqb8.jpg
>>
>- Thanks in Advance
>>
>- Mark

>
I would try to reset the menu bar.
>
Right click a menu bar, select customize. In the Toolbars tab, select
menu bar, and hit reset.
>
If this doesn't work, then I don't know, I'm afraid.
>
--
Roy-Vidar
>
>