Locked Out Of VBA

[bigot]

I am 100% to blame for this, I'm hoping one of you can bail me out.



I recently became aware that the "Shift" bypass thing works on .accde as well (initially, I thought it was just an .accdb thing, and .accde automatically locked people out). In an attempt to disable it, I came across this article. So I script-kiddied those two functions and ran ap_disableShift... then I closed and reopened the database.

Now I'm locked out of my own VBA ("Use Access Special Keys" is disabled). I can't edit any forms or figure out any way to run the code to re-enable the bypass key.

Oh, and I am so smart that I did not make any back ups...

Any ideas/suggestions?

[ItsMe]

I am going to send you a PM.

[bigot]

Thank you ItsMe, you saved my butt, +rep.

Out of curiosity, is there a reason you didn't post that code publicly (too dangerous)?

[ItsMe]

As you can see, it is nothing special. I believe lazy people are more apt to wreak havoc on others. So I chose not to make it easy for lazy people.

[HiTechCoach]

I am 100% to blame for this, I'm hoping one of you can bail me out.

I recently became aware that the "Shift" bypass thing works on .accde as well (initially, I thought it was just an .accdb thing, and .accde automatically locked people out). In an attempt to disable it, I came across this article. So I script-kiddied those two functions and ran ap_disableShift... then I closed and reopened the database.

Now I'm locked out of my own VBA ("Use Access Special Keys" is disabled). I can't edit any forms or figure out any way to run the code to re-enable the bypass key.

Oh, and I am so smart that I did not make any back ups...

Any ideas/suggestions?

TIP: Only disable the shift-bypass on the front end after is is compiled into a mde or accde and ready to deploy. Never on you master copy.

[bigot]

TIP: Only disable the shift-bypass on the front end after is is compiled into a mde or accde and ready to deploy. Never on you master copy.

Very good advice. I re-wrote it so it auto-disables only on .accde types!

[HiTechCoach]

Very good advice. I re-wrote it so it auto-disables only on .accde types!

Great minds think alike. That is exactly what I do. I have the startup code check for a compiled database and lock it down every time. Before deploying I open it once to "lock'er down".

[bigot]

Interestingly enough, I already had this code on the database. But I hadn't run the accde version without the bypass key.

Lesson learned: if you're going to make accde proprietary code, make sure to open the database at least once without bypassing :P