+ Reply to Thread
Results 1 to 2 of 2

Password Protect a Table

  1. #1
    Forum Contributor
    Join Date
    11-14-2007
    Posts
    111

    Password Protect a Table

    Hello

    i want to create a password field that can only be changed by entering the original password for the field. how would i do that?

    Thanks
    Last edited by Ada01; 11-04-2010 at 03:09 PM. Reason: new thought

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Re: Password Protect a Table

    Ada01,
    Create a form that has 2 text boxes.

    Old Password:

    New Password:

    Create an ADO/SQL statement that would open the record where the password is stored.

    Then do and IF - THEN statement. To check if the old password is correct then overwrite it with the new one.

    Hope this helps,

    Dan
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1