Not able to view menu items in Access

[supportt]

I have an Access DB that when starting, none of the menu items are visiable. I did use the shift when opening the database and it prompts me for a password (and I enter the correct one), but none of the menu items are there. Whoever created it, must have locked out those items. My question is, can I get in to add some new fields????

Thanks

David

 

[Pat Hartman]

I just had this happen to me on one of my own db's. Turns out to be yet another manifestation of the "reference" problem. If you don't know what I'm talking about, search the site for "missing references" to find the solution.

 

[supportt]

I don't think that was the problem

Thanks for the reply, but I don't think that was the problem....I did a search for missing references but did not have any luck resolving my issue.

The problem is, someone else created this database and they disabled the menu items so no one could edit the DB. Now the customer is coming to me and wants to add two new fields, but can not get in the edit mode.

Thanks

 

[WayneRyan]

David,

Can you import all objects into a New, Blank database.

Wayne

 

[mdemarte]

missing menu items

I 'inherited' a database that does that. The previous programmer set it up to limit the users access. I hope that I can explain this so it makes sense.

First, to get into it, try PF11 to get past the menus and into the tables. Second, look for either a macro in the database that runs at startup or one labeled AUTOEXEC. It probably has a SetValue in it for the [Application].[menubar]. Cut that entry out and paste it into the comments section -- leave behind the quotes. Now, rerun the macro and you should get the menus back.

After you are done editing it and you want to put it back into place, you can then copy the entry back into the middle of the quotes.

For what it's worth, I had problems with the users being able to add, delete and print records when limited to the menu bar, so I have kept it out.