How to open/develop Access with password & Shift key protection

[Pavloo]

Hello
I have to resolve a problem with MS Access 2010 application.
With MS Access/VBA I have very little experience.


This application has a password. But I do not know it (I am able to remove it via XVI32.exe application).
Application has also enabled Shift key protectioin option.
Navigation window and the menu bar are disabled.


How can I get into this app to develop it?


What did I do so far?
I removed the password from the application. However, I still can not enter into the VBA editor, because I can not open it to edit (Shift key protection).


Another approach - I opened a new empty database and import all the elements from original application - then I could edit the application, view/edit the VBA code. However, the application does not work properly (some operations crashes). I suspose that the bugs are the result of importing application to a new one (but I could wrong).


So is there any other way to open/edit/develop this original application?
Is it possible to disable the Shift key protection without necessity editing VBA code (I am not able to get in there)?


Any help would be appreciated.


Regards
Pavloo

[ranman256]

its possible you did not import everything. hence the crash. (relations, schema,etc)
Normally, shift key disables the macros at start, so when you say disabled shift key protection,
do you mean you disabled the shift disable? Which means Shift key does not work to disable?

in the immediate window, Ctl-G,
CurrentProject.Properties.Add "AllowBypassKey", true

or run it in vb code in any form.

[Pavloo]

I think, that I imported everything.
When I said/asked how to 'disabled shift key protection' I meant that in oryginal application it works fine and when I try to open application with pressed down Shift key it opens normaly.
And I can't go into VBA editor.
But my aim is to go into VBA editor.


So is it possible to switch off this Shift key protection on oryginal application (not using VBA in immediate window)?
Because as I wrote earlier - when I import Application with all components, I have many errors like 'Run-time error 3326 This Recordset is not updateable'.
On oryginal app there are not any errors like that. It's occured after importing application.

[aytee111]

Can you Alt + f11 to open the VBA Editor?

Evidently it can be done thru a macro - don't use them myself but here is an explanation:
https://support.office.com/en-us/art...3-33042953a5f9

You can also open this database from another database and set this option.

(When you import objects from an Access database, at the bottom of the import window there are more options and buttons to select, these are often forgotten or bypassed.)

[Pavloo]

Well, Alt+F11 does not work.
I do not know why.

Earlier when I imported objects from that Access to a new one, I selected all options. And even that, some operations in application crashed.

Any other suggestions how can I enable "Alt + F11" in original Access application?

[Pavloo]

I have just solved my problem.
This helped me:
https://answers.microsoft.com/en-us/...c-c96a793f641e

Thanks for all yours suggestions!