Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Trial & Error, Nov 10, 2005.

  1. Trial & Error

    Trial & Error
    Expand Collapse
    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....
     
  2. Loading...

    Similar Threads Forum Date
    General Great Production of English Songs and scene settings Videos Oct 11, 2012
    Hinduism Why is there Dancing in Bhajans or in Mandir Settings? Interfaith Dialogues Feb 18, 2011
    Personal Goal Setting. Why Set Goals? Business, Lifestyle & Leisure Oct 23, 2010
    Rise in Extremism or Rise in Hysteria? Canadian Sikhs Setting the Record Straight Hard Talk Apr 25, 2010
    Sikh News Badal invited to Pakistan for setting up of Nanak varsity (New Kerala) Breaking News Nov 23, 2009

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    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.

    --
    Rick B



    "Trial & Error" <TrialError@discussions.microsoft.com> wrote in message
    news:715379F9-20F5-4F36-9264-46CF055B5655@microsoft.com...
    >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....
     

Share This Page