Re: database open control

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.

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


"K. Shoghi" <KShoghi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E968442-CFF0-4DEC-AC4F-7E1E8A41ECBB@xxxxxxxxxxxxxxxx
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" wrote:

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)

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


"K. Shoghi" <KShoghi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F89D64A7-AE97-466C-9EB7-0D06FE35FCE7@xxxxxxxxxxxxxxxx
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?





.