Hello,

A client has given me a DB created by a contractor and would like me to make some changes. I am a bit rusty when it comes to Access programming and can't seem to open the code window or form designer.

I have tried alt+F11 which gets me nothing and the developer also removed the majority of the tool bars and the ones left are severely restricted.

Oh, the DB opens directly to a Form and all additional choices are through forms.

Before I go back to the client, hat in hand, and tell them I can't even get into design mode, are there any things that I can try?

I appreciate any and all help!

Is this an MDE file? If so, you are out of luck: in MDEs, the code is completely compiled and locked away, forever out of reach to mere mortals.

Patrick

nope, it is a .MDB file.

If the mdb has security applied, it could be that your user/group permissions do not grant you access to design objects...

ok, I appreciate the feedback.

I should be able to get to the design objects or code by typing alt+F11 correct?

If not, that means there is security enabled?

I appreciate the patience,

Snuffles,

To be honest, I am not an expert on Access security. I know enough about it that I do not recommend using it :shock:

Alt-F11 should call up the VB Editor, unless of course your predecessor implemented code that disabled that hotkey combination (I know how to do that in Excel, but not in Access, but presumably it's possible).

Patrick

Thanks Patrick,

You gave me enough confidence to go back and ask how to get at the code or get the DB into design mode.

Wanted to make sure that I did not miss something really simple!

Good luck with your project!

Try Shift + F11