Bypass Key Combination (Macro)

[Tom]

I use Garry Robinson's "Startup Properties" form to disable/enable my bypass
key.

For security purposes, as desired, holding down the SHFT key while
double-clicking on the MDB file does not allow me get "behind" the
application and gain access to the Database Window and any menus.

Currently, as the administrator, I use "^K" in order to open up my Startup
Properties form where I can enable the bypass key again.

Okay, my concern is that the simple combination of "^K" could be easily
figured out by simply going through the alphabet.

Here's my question: How can I setup a combination of e.g. "^K^E" in my
AutoKeys macro? I think that would create more security on the system.
Currently, when adding "^K^E" in the "MacroName" of my "OpenForm" action, I
get the error: "The key or key combination ^K^E in AutoKeys has invalid
syntax or is not allowed."

Any ideas how to create a more complex combination?

Thanks,
Tom

 

[ZH875 via AccessMonster.com]

There is an excellent little Access DB program by Dev Ashish called 'Secure.
mdb' this enables you to set properties and to enable/diable the startup
bypass without any autokeys macros in your database.

 

[Tom]

Excellent, any ideas where I could find it?

Tom

 

[Douglas J. Steele]

http://www.mvps.org/access/resources/downloads.htm#S at "The Access Web"

It's the 3rd one down you want: Secure (from Terry Kreft)

Albert Kallal also has something at under "By Pass Shift Key Code" at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Tom]

Douglas,

thanks for chipping in...

ok, I checked out Terry's db... when opened, the form "asked" for selectingn
a System Database, Login, and Password... not sure what to put in there.

Also, I already have a Startup form where I'm setting my properties. This
startup form is linked to my macro which uses the custom key in order for
one to open the db. Again, my initial idea was to find out if I could
create a more complex key (2 letters vs. 1 letter)... the likelihood of
guessing a complex key is much smaller than a single key.

However, since posting my original message, I have come across a sample db
that allows anyone to a) select a db and then b) open the Startup form, c)
set the Bypass key in the startup form. Essentially, the sample db is a
"code cracker". Not sure if everyone comes across it, but just in case...

So, there's no way of creating such complex key combination e.g. "^K^E" in
my macro? But then, w/ the "code cracker" sample db, it's useless either
way.

Tom

 

[ZH875 via AccessMonster.com]

The system database is the 'system.mdw' file, just browse to where it is
Database name is the database you use, just navigate to that
If you have not set up passwods in the system.mdw, then Login will be 'Admin'
and Password will be blank.

All this is explined in the helpfile for that program

Rgds
ZH

Douglas,

thanks for chipping in...

ok, I checked out Terry's db... when opened, the form "asked" for selectingn
a System Database, Login, and Password... not sure what to put in there.

Also, I already have a Startup form where I'm setting my properties. This
startup form is linked to my macro which uses the custom key in order for
one to open the db. Again, my initial idea was to find out if I could
create a more complex key (2 letters vs. 1 letter)... the likelihood of
guessing a complex key is much smaller than a single key.

However, since posting my original message, I have come across a sample db
that allows anyone to a) select a db and then b) open the Startup form, c)
set the Bypass key in the startup form. Essentially, the sample db is a
"code cracker". Not sure if everyone comes across it, but just in case...

So, there's no way of creating such complex key combination e.g. "^K^E" in
my macro? But then, w/ the "code cracker" sample db, it's useless either
way.

Tom

http://www.mvps.org/access/resources/downloads.htm#S at "The Access Web"

[quoted text clipped - 39 lines]

 

[Douglas J. Steele]

Autokeys doesn't allow for combinations like you're suggesting. You could,
however, have Ctrl+Shift+K as your required key combination by specifying
+^k in your macro.

As to the "code cracker" database, it sounds as though you haven't applied
Access Security to your database, though, so you're correct that it's pretty
easy to reset the property. If you do have Access User-Level Security
applied, it's much hard to reset the AllowBypassKey property when you use
the correction shown in http://www.mvps.org/access/general/gen0040.htm at
"The Access Web"