Results 1 to 6 of 6
  1. #1
    pbeattie687 is offline Novice
    Windows 2K Access 2003
    Join Date
    May 2012
    Posts
    3

    Password protect individual forms in Access 2003


    Hi

    I have created a database with a form that is protected by a password, but in order for the password to be set the user needs to convert the string into keycode. For example, during testing the password used is PASSWORD with the code 2818. It would obviously be better for the user to be able to change this password without having to know the code.

    To make the password I orginally followed another tutorial so am a little out of my comfort zone.

    THanks

    pb

  2. #2
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    I have a few questions that might sound stupid:

    Since you need a password, are you using it across a network (i.e. will every user have their own unique windows login) because then potentially there is another alternative.

    Otherwise we need at the very least a link to the tutorial you used, because without that (or a copy of your project for analysis) we have absolutely no idea at all how the mechanism works.

  3. #3
    pbeattie687 is offline Novice
    Windows 2K Access 2003
    Join Date
    May 2012
    Posts
    3
    Hi

    Here is the tutorial I used:

    http://www.oocities.org/heartland/po.../Form4.htm.tmp

    It works perfectly for what I need - basically a system on one PC shared between different users.

    The difficulty lies in


    To determine what the corresponding KeyCode is for a given string, type the following into the Immediate window and press ENTER:
    ?KeyCode("TestString")
    The above example returns 5864.
    To what window is this referring? (Stupid question I know!)

    Does this help.

    Thanks

    pb

  4. #4
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    In the visual basic editor look for the immediate window.

    This provides a little description
    http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx

  5. #5
    pbeattie687 is offline Novice
    Windows 2K Access 2003
    Join Date
    May 2012
    Posts
    3
    Helps - thanks

    Bit of an awkward way for the user to update the password though!

    pb

  6. #6
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    Imho users should never be allowed into vb, tables or queries.

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

Similar Threads

  1. Password Protect Buttons on Forms
    By Desstro in forum Forms
    Replies: 13
    Last Post: 08-24-2012, 05:04 PM
  2. Password Protect an Email Attachment in Access 2007
    By amangupts in forum Programming
    Replies: 3
    Last Post: 12-21-2011, 04:37 AM
  3. Replies: 5
    Last Post: 12-20-2011, 06:48 PM
  4. Password Protect Forms
    By jlclark4 in forum Security
    Replies: 3
    Last Post: 01-25-2011, 04:26 PM
  5. Password Protect Forms
    By Robert M in forum Programming
    Replies: 3
    Last Post: 01-15-2010, 01:50 PM

Tags for this Thread

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