Bypass Shift Key at Startup

[htmlasp]

Hello,

I am able to bypass the shift key so I can disable ribbon and all menus at startup.

But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning:

"Security Warning - some active content has been disabled, click here to enable"

and it gives them complete access to see the back end of the database because while that warning message is popped up ... before they click "enable" they can go do anything in the database including see tables, data, and vba.

Once they click "enable content" that first time the bypass takes effect and the ribbon and all menus disappear, but if they dont click it they can navigate all around the db

how can i stop that?

thanks...

 

[CJ_London]

A couple of possible solutions:

1. Have them open a db containing just an autoexec command to open the 'real' db - suggest this is an accde so the cannot vew the code.

You may also need to set trusted locations which will prevent the warning being activated in the first place - although it will occur the very first time the db is opened

2. Disable the bypass key - but put a button that is only visible to you on a form that you can click to renable the bypass key - you then need to click it then drop out and go back in again.