Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012

    Unanswered: Lock down database until username & password entered

    I have made a login screen for my access 2007 database using a pop-up form with two textboxes and a button. The button has an on_click event which runs some VB code which extracts the strings from the text boxes and compares them against a table. If successful, the main menu opens.

    Is there a simple way of stopping the user just being able to double click on the forms on the right hand side and opening them? i.e. so that they HAVE to enter their details first?

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Make the form modal.
    Code something in the Exit events of the text boxes to ensure that they have to contain a value before they're allowed to leave.
    Use API calls to pick up the user's account details, and validate them as/before the form opens.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts