Locked DB Forms only

[Jhill55]

Hey guys,

I was hoping someone could help me out. I need to edit an old DB but I can't access anything when I open it. All I can use are the forms that were made. I need to be able to being in the queries, tables, moduels, etc. I've tried holding down the shift key when I opened it and that does not work. Any ideas?

Thanks

 

[OptimisticYid]

Try F11 once you are at the form stage, alternatively you could just try creating a new database and then importing existing structure and data.

 

[Jhill55]

F11 doesn't work. I have no idea really what the existing structure is, that's why I need to get into it and dig around.

 

[miltiadis21]

try this Ctrl + . on a form or going into access options and enable dispay navigation panel or show hidden objects

 

[Dennisk]

hold the shift down when you open the db. Then select windows unhide. As I suspect the db windows (tables, queries, forms etc) has been hidden in the startup parameters.

 

[Jhill55]

Thanks for the input, but I'm still locked out. Shift F allows me to edit the form. But the only thing I can do is move objects around. I cant even right click and view properties. Windows does not show the "unhide" option.

Thanks again guys.

 

[georgedwilkinson]

I'm sure you've checked to see if the file is read only?

 

[Jhill55]

It's not. If I can just get into the tools and turn it all back on..

 

[DJkarl]

Are you sure this is an mdb file, sounds like it might be an mde file if you aren't able to access the code, reports, and forms.

 

[Jhill55]

it's a MDB.

 

[DJkarl]

Then it sounds as though someone has disabled the shift bypass feature as well as turned off disabled most of the shortcuts and menus. The shift bypass can only be reinstated through code.

 

[Jhill55]

Will I be able to create code in one DB and then reference the directory of the locked DB?

Thanks for all the feedback.

 

[Jhill55]

Got it. I had to open the VBA window before I opened the DB. I then used the code CurrentDB.Properties.Delete("AllowBypassKey"). I ran it, closed the DB and reopened with the shift key.