database open control

[Guest]

Hi all, I have set my data base to ask for password when it opens, if the
password is wrong it wont open the database, but when the user presses Shift
and open the database it baypass all the start up settings, is there any way
to password protect the open database while holding shift? or direct it to
run a procedure or open a certain form while database is opened by holding
shift?

 

[Douglas J Steele]

What kind of password are you talking about?

If a database password, the shift key shouldn't matter.

If you've applied user-level security (so that users have to provide both a
User Id and Password), you haven't applied it correctly, as it's not that
easy to bypass.

If you've applied your own security, how are you doing it? (Be aware that
home-grown security approaches seldom work)

 

[Guest]

I have a table Password, and a form that asks user to enter the password and
it looks up the password table for matching entry, i also have a counter that
if the user has type wrong password 3 times, it quits the database.

I have cleared all the check boxes in startup at tools menu and have
directed the data base to run the password form at start up.

it works fine, but as i said if the user press shift while opening the data
base, it bay pass the startup options that i have set at tools, startup. so i
need to either stop the shift function, or direct the data base to open a
certain form if the shift is pressed while opening the data base.

thanks for reply

 

[Douglas J Steele]

Well, you're fooling yourself if you think it's going to keep anyone out of
your database (they can simply import everything into a new database), but
what you want to do is create a Database property named AllowBypassKey, and
set its value to False.

See http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for
the correct way to create this property.