Missing menu in Access 2010 (1 Viewer)

[ians]

NOW SOLVED (see bottom of this post)

I inherited a database to change.

I've edited an accdb file (changing the linked tables), which all works fine - all data now being read from/written to the new location.

I now want to create the accde. When I Save As I get the message:

"You cannot create .accde from a disabled database ... you can create it by using the message bar."

When I click on the message bar the whole menu disappears so I can no longer do a Save As and cannot create the .accde (nor anything else, of course). Whenever I open that .accdb file now the menu is missing. On screen I've only got the Form and, on the left hand side, the "All Access objects" column.

How do I get the menu back? The database is in a trusted location. I've tried shift clicking, but that doesn't change anything.

Thanks.

SOLUTION: I used Alt+F11 to get to the code, the added the following line to the Form's onload section:

DoCmd.ShowToolbar "Ribbon", acToolbarYes

 

[Pat Hartman]

Welcome aboard
Thanks for posting your solution but the ribbons are displayed by default so if you had to add code to show them, there must be some code that is hiding them. Perhaps you should find that code and fix it or get rid of it.

 

[ahmed khater]

Thanks guys
I was looking for it