shift key access to secure Db

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Hi,
Can anyone help me with a security problem? How do I keep people from
accessing objects in a secure Db, via the shift key back door
method? Assuming that there are various methods of achieving this
result, I'll ask for the simplist method, since I fear that the
"best" method will prove to be too complicated.
Thanks to all who reply
 
If it is pre-Access2007 then you want to check out User Level
Security....read up on the security aspects of the product - and see dialog
in Security area of this forum....
 
Look up the AllowBypassKey property in VBA help (code example included).
Pretty simple.

Now, how to implement. That depends a lot on personal preference.

What I do is set AllowBypassKey to False in a set of code that is called by
an AutoExec macro, so it runs automatically whenever the DB is opened
normally. The db becomes secure the first time it is opened without shift
pressed, so I try to make sure I deliver it that way, but if I forget, its
not likely to be long before the situation corrects itself, so no harm done.

I also include a "backdoor" within the app so that by clicking on the header
of my main menu I can turn AllowBypassKey ON (possibly after supplying a
simple password). Then I can close the app and reopen it with shift pressed.

But the first time I forget to press shift while opening, the db will lock
itself again, which is exactly what I want.

If you find yourself unable to use your backdoor because your app is
generating errors when it opens, you can open a new blank db and write 3
lines of code that will allow you to get in:

Dim dbs as DAO.Database
Set dbs = OpenDatabase("full path and file name to mdb")
dbs.Properties("AllowBypassKey") = True
 
Hi,
Can anyone help me with a security problem? How do I keep people from
accessing objects in a secure Db, via the shift key back door
method? Assuming that there are various methods of achieving this
result, I'll ask for the simplist method, since I fear that the
"best" method will prove to be too complicated.
Thanks to all who reply
Click to expand...

Our friend (former MVP, now Microsoft employee) Jeff Conrad has some links:

http://www.accessmvp.com/JConrad/accessjunkie/shiftkey.html
 
Back
Top