Question Locked down database

[wmeads001]

My access experience is not that great. I have inheriated a database.mdb that is locked down completely. I am using MS 2007

When I say locked down completely I mean

1 F11 does work and displays a list of objects
2 You can ctl enter to get the design view of the form table etc
3 There is no ribbon display at all and the MS button is also not displaying
4 Right click does not work any where
5 You can access VBA and I have looked at the VBA including that which is attached to the forms. There does not appear to be any thing.
6 There is no autoexce macro
7 A form loads automatically on starting the database

so my questions are

How can I get the ribbon to display all its normal items and "Restore" all the normal design functionality

 

[GinaWhipp]

Sounds like some start up options are in place. Can you get to Options?

Options
Options for Current Database

...mimic what you see under Options for Current Database and then post what ones are still not fixed.

 

[wmeads001]

Sounds like some start up options are in place. Can you get to Options?
...mimic what you see under Options for Current Database and then post what ones are still not fixed.

Thanks GinaWhipp.

There are no menu items or the options page available at all

I am comming to the conclusion that this has been handled by some VBA but there are hundreds of forms all with their own VBA and it looks like I will have to examine each of them as it could be an obsure form that is loaded on startup.

There are two functions in a module that enable and disable allowbypasskey but I can not find the calling function. When I comment out these functions save and reload the database there is no change.

 

[John.Woody]

Run the function which disables the allowbypasskey and see if that frees things up.

 

[CBrighton]

AllowBypassKey should allow you to hold shift while opening the database (or is it at the enable macros stage on 2007? I have limited experience of 2007).

From there you should have the normal menus and can sort the rest out (assuming you want the end user to access the stuff you were talking about. If it's just you then toggling the bypass key on and off should be all you need to do).

:edit:

Worst case, launch the function via a macro or create a new form with a command button which runs the function.