Unable to view code

[jsic1210]

Hello,

When saving my accdb as an accde, I disabled Special Access keys. I also have the toolbar hidden for the front end users.
Normally, I leave the vba code open, so I can type "DoCmd.ShowToolbar 'Ribbon'" but forgot to do so this time.
I can't figure out how (if there's a way) to get back into my code in the accdb copy. I have code that disables the shift key, so that's not an option.

Is there a way to get back into my code or enable the special access keys?

Thanks,
Jeff

 

[pbaldy]

Try Alt-F11

 

[jsic1210]

Because I disabled special keys, this doesn't work.

 

[Frothingslosh]

If you've disabled the shift bypass and special keys, then you'll need to get a bit more creative. What you may need to do is create a blank database and then import all the objects from your existing one.

And after doing that, don't forget to leave yourself (and future successors) a back door - mine is usually either a password-protected maintenance menu or an image that, if double-clicked, disables the shift bypass if the correct password is entered. (Or special startup code that triggers if a DEV command switch or developer environment is found.)

 

[cyanidem]

Another idea is to remotely enable special keys, something about it in this thread:
http://www.utteraccess.com/forum/lofiversion/index.php/t1263110.html
See TheSmileyCoder's post.

 

[pbaldy]

Bill has a utility here if the other options don't work:

http://www.thatlldoit.com/Pages/utilsaddins.aspx

 

[jsic1210]

Okay, thanks for the all the replies!

I used Frothingslosh's advice, created a new database and pasted all the objects. I also created a way out as suggested (a password protected command that shows the ribbon). That seemed to have worked.

Jeff

 

[Frothingslosh]

Just for the record, mine was the brute force approach. I actually think both of the other two provided are decidedly more elegant than mine, but I'm happy to have helped.