Results 1 to 6 of 6
  1. #1
    cindytan is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2012
    Posts
    11

    How to restrict users?

    Is it possible just to restrict the users from keep trying their password again continuously at the login form. eg. after 3 tries of password, they have to wait for a certain minutes in order to try again?

    If macro can do this, what the action of the macro? (no VBA)

    Thanks all in advance.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    I don't use macros, only VBA, so not sure how or if macro can handle this.

    One way would be to increment a value in an unbound textbox or caption on a label or increment a global variable. Refer to that control or variable with each attempt. If it is 4th attempt then close project or somehow enforce the time hold.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cindytan is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2012
    Posts
    11
    thanks, but i not sure how can i go about doing and which macro action to use...

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    The code (macro or VBA) would be associated with an event such as a textbox AfterUpdate or button Click. As I said, don't know if macro can do this. I would use VBA.

    I guess the macro 'action' would be after user enters id/password to check the value of the attempts variable and if it is 3, lock them out.

    In VBA the code would be like:

    'id/password entries not a match
    If Me.tbxAttempts = 3 Then
    MsgBox "3 login attempts allowed. Database will now close."
    DoCmd.Quit acQuitSaveNone
    Else
    MsgBox "ID and/or password do not match. Try again."
    End If

    No idea how to translate that to a macro.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    jhcarrell's Avatar
    jhcarrell is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Alabama
    Posts
    10
    Another approach would be to have a modal dialog form that is set to close after a set duration popup after x number of attempts. Set the dialog form to close after a set duration (much like a splash screen).

    This wouldn't stop a user from closing access and reopening to try again.

    You could also set up a table to track login attempts and set up code to manage logins based on it.

  6. #6
    cindytan is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2012
    Posts
    11
    thanks all for the help anyway, i don't seem to have enough time to figure out how to create all these. I am not sure of the steps and which macro i should be using.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-26-2011, 03:12 PM
  2. How to Restrict the Listbox on double click
    By ganeshvenkatram in forum Access
    Replies: 2
    Last Post: 07-07-2011, 10:05 PM
  3. Restrict Table values
    By Suzied in forum Access
    Replies: 1
    Last Post: 03-27-2010, 11:14 AM
  4. Restrict Combo Box Options
    By KWarzala in forum Forms
    Replies: 1
    Last Post: 03-03-2010, 04:46 PM
  5. Restrict form access to certain people
    By DannyBoy7783 in forum Forms
    Replies: 2
    Last Post: 06-09-2008, 06:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums