Bypass Key Combination (Macro)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 25 Feb 2006 03:52 GMT

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

Reply to this Message

ZH875 - 25 Feb 2006 13:14 GMT

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.

>I use Garry Robinson's "Startup Properties" form to disable/enable my bypass
>key.
[quoted text clipped - 19 lines]
>Thanks,
>Tom

Reply to this Message

Tom - 25 Feb 2006 14:46 GMT

Excellent, any ideas where I could find it?

Tom

> There is an excellent little Access DB program by Dev Ashish called
> 'Secure.
[quoted text clipped - 26 lines]
>>Thanks,
>>Tom

Reply to this Message

Douglas J. Steele - 25 Feb 2006 14:55 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Excellent, any ideas where I could find it?
>
[quoted text clipped - 31 lines]
>>>Thanks,
>>>Tom

Reply to this Message

Tom - 25 Feb 2006 15:17 GMT

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]
>>>>Thanks,
>>>>Tom

Reply to this Message

ZH875 - 25 Feb 2006 17:26 GMT

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,
>
[quoted text clipped - 25 lines]
>>>>>Thanks,
>>>>>Tom

Reply to this Message

Douglas J. Steele - 25 Feb 2006 21:11 GMT

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"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Douglas,
>
[quoted text clipped - 21 lines]
>
> Tom

Reply to this Message