Indirectly enabling bypasskey

[makyland]

Hi!

I have already read through all the posts regarding bypasskey but haven't
found the exact answer I'm looking for...

I'm already experienced in adding security to my Access applications: I use
user-level permissions, I disable bypasskey and on startup I disable every
access to built-in menus, hide database window, disable special keys... I
also distribute mde files and some additional files of my application are
distributed hidden.

However I feel disappointed because "everything" is not enough! as you can
very easily enable bypasskey through code (for instance using shiftkey2000
piece of code). You can very easily change the properties of a database...

So I don't see a way to 100% protect my Access application as an experience
user would easily have access to the database window and skip startup
options.
Also you can easily download free tools to read admin users and passwords
from mdw files, so... is there any way to increase protection on this?

Is there any way to absolutely prevent bypasskey from being enabled?

Thank you in advance from any comment on that!

 

[Rick Brandt]

Hi!

I have already read through all the posts regarding bypasskey but
haven't found the exact answer I'm looking for...

I'm already experienced in adding security to my Access applications:
I use user-level permissions, I disable bypasskey and on startup I
disable every access to built-in menus, hide database window, disable
special keys... I also distribute mde files and some additional files
of my application are distributed hidden.

However I feel disappointed because "everything" is not enough! as
you can very easily enable bypasskey through code (for instance using
shiftkey2000 piece of code). You can very easily change the
properties of a database...

So I don't see a way to 100% protect my Access application as an
experience user would easily have access to the database window and
skip startup options.
Also you can easily download free tools to read admin users and
passwords from mdw files, so... is there any way to increase
protection on this?

Is there any way to absolutely prevent bypasskey from being enabled?

Thank you in advance from any comment on that!

If you use Access User Level Security then there is a way to disable the bypass
key such that it can only be reset by a user with administrator authority. I
don't recall more specifics about that, but if you search these groups it is
mentioned with some frequency.

Of course, Access user level security is also breakable if the user wants to
acquire the tools to do so. Ultimately, data with "real" security requirements
does not belong in MDB files.