Other ways to open vba editor?

[Coatezy]

Hi, I have used a number of ways to lock down my database... 1 Disable Shift on start, 2 used xml to hide the qab and ribbon, 3 used vba to also disable qab and ribbon, 4 disabled access keyboard short cuts etc etc.. Problem is ones I use all these at once how will I be also to access vba editor if I ever need to again.. as The keyboard shutcut will be disabled and there will be no ribbon etc etc.. I will also be adding a password to the vba so it appears I cannot use a macro to open the vba edior which is activated by a cutom keyboard shortcut..

Hmmm anyone have any ideas?!

Thanks
Coatezy....

 

[JANR]

Ctrl+G opens VBA codewindow.

JR

 

[chergh]

Don't lock down your DB so much?


I lock my DB's down enough to prevent accidental damage and make sure there are regular back ups so any malicous damage isn't to bad. I've also never had a case of malicous damage and if i did whoever was responsible would be straight out the door.

 

[Coatezy]

Ctrl+G opens VBA codewindow.

JR

By disabling access short cuts it also disables Ctrl+G lol...

 

[Coatezy]

Don't lock down your DB so much?


I lock my DB's down enough to prevent accidental damage and make sure there are regular back ups so any malicous damage isn't to bad. I've also never had a case of malicous damage and if i did whoever was responsible would be straight out the door.

Unfortunately I need to lock it right down..

 

[JANR]

By disabling access short cuts it also disables Ctrl+G lol...

live and learn...

 

[Coatezy]

live and learn...

I didn't even know Ctrl+G was a short cut until last night when I was setting up custom short cuts.

 

[Atomic Shrimp]

Unfortunately I need to lock it right down..

Wouldn't it be easier just to distribute it as an .accde ?