RE: Passwords To Identify Users And Populate date/timestamp

Tech-Archive recommends: Fix windows errors by optimizing your registry

Mary,

Here is how I have done it.
I have a table in my back end that contains User Id and Password fields. I
have an encryption routine that makes them unreadable.
When a user logins in, I encrypt his/her id and password and look to see if
the user is in the database and if the password is good.
If it is a valid user, I create two application level properties. UserID and
UserPassword and assign the values to the properties.
Then when you need the values (not encrypted, by the way) you can reference
the properties.

"Mary Bowman via AccessMonster.com" wrote:

> I have six Users that will update the table. I have a password pop-up box
> to enter a password in order to open the form and edit records. How do I
> give (6) separate passwords to each User and then auto populate the form
> with the user name, date and timestamp while they edit each record.
>
> Below is my password code, but how do I from the password, identify the
> User and then populate the record with the name and timestamps?
>
>
> Dim F As Form
> Set F = Forms![frmPswrdEdit]
>
> If F!pwd = "awesome" Then GoTo pwd_success
>
> If F!pwd <> "awesome" Then GoTo pwd_invalid
> If IsNull(F!pwd) Then GoTo pwd_invalid
> If Len(F!pwd) = 0 Then GoTo pwd_invalid
>
> On Error GoTo pwd_trap
>
> pwd_success:
> DoCmd.Close acForm, "frmpswrdEdit"
> DoComd.Open “frmClientUpdate”
> Exit Sub
>
> End Sub
>
> Thanks,
> Mary Bowman
>
> --
> Message posted via http://www.accessmonster.com
>
.

Relevant Pages

  • NTE_BAD_DATA
    ... decryption module using the self signed certificate. ... My encryption and decryption module are as follows. ... goto Exit_MyDecryptFile; ... // imported from a BLOB read in from the source file or having ...
    (microsoft.public.platformsdk.security)
  • NTE_BAD_DATA
    ... decryption module using the self signed certificate. ... My encryption and decryption module are as follows. ... goto Exit_MyDecryptFile; ... // imported from a BLOB read in from the source file or having ...
    (microsoft.public.platformsdk.security)
  • Re: [BUG] MMC/SD: SDHC card capacity not correct
    ... goto out; ... I prefer the second fix, ... Send me a proper patch with a S-o-b and all that. ... Make sure your server uses encryption ...
    (Linux-Kernel)
  • Re: [Full-Disclosure] Time Expiry Alogorithm??
    ... > account for somehow incorporating a timestamp into ... > the encryption scheme to prevent 'legit' decryption after a certain time. ... sufficient to decrypt the message alone), give one part to the recipient, ... Not for ciphertexts already encrypted with shorter keys. ...
    (Full-Disclosure)
  • Re: Combine Secure 3DES Encryption with ability to count occurence of known plaintext - how to accom
    ... >The problem I have is the limited capabilities of the HSP. ... When I have a transaction, ... add, timestamp) to set B. ... Ecould be a deterministic encryption algorithm, or it ...
    (sci.crypt)