Bypass Key Combination (Macro)

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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.
 
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
 
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"
Click to expand...
[quoted text clipped - 39 lines]
Click to expand...
 
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"
 
Back
Top