Setting a Password on a Form... not the whole DB

[Guest]

I have a registration DB used to accept school bookings etc.

I need to have some way for a user to run MAJOR edits on registration
information.
To accomplish this, I have generated a form that contains every field from
the booking table. It displays the records in Datasheet view. Technically, a
user could access this page, highlight the entire record set and delete every
existing booking.

This is what I wanted this form to be able to do... but I want to be sure
only a few people can access that form.

Ideally I would like the form to load and automatically prompt for a
password.
I dont want a password table anywhere in the DB... I would like to burry the
accepted password within the code used to prompt for the password.

the form in question is "PSWDSchBooking"... for this example... lets make
the Password : "ogpogo"

Does anyone know of a simple procedure that could be used to accomplish the
function I am explaining.
I dont care if its not "Perfect"... this isnt an overly sensitive DB... I
just want the user to be promted for a "code"... maybe allow for 3 tries, and
then close the form.

I dont need the user to be barred from the DB or anything fancy.

The PSWD i mentioned would be a word that I myself would know... and maybe
the primary user of the DB.

Thanks for any help any of you may have.
Examples of any code would be appreciated....

So far Im thinking it would be code falling under the "OnOpen" event....

 

[Rick B]

Rather than jumping through all these hoops, why not simply use the built-in
User Level Security and only give access to the form to people who need it?

You are trying to come up with a "simple" way to do this without securing
the whole database, but it is gonna take you much longer than just using the
tools already there. Just make two userids, one that can get to the form
and one for everyone else. Make their password "space" if you want to make
it super easy for them.