Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Randomisation

Discussion in 'Information Technology' started by CRAIG MORRIS, Jul 28, 2006.

  1. CRAIG MORRIS

    CRAIG MORRIS
    Expand Collapse
    Guest

    I would like to ransomise Usernames and Passwords in a database so I can
    automatically assign them to registered users.
     
  2. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Craig,
    I'm not sure if it's really necessary to randomize UserNames... I would think just the
    randomized passwords would suffice. You're call...

    See Randomize statement, and the RND function in Help.

    If you'll need combinations of letters and numbers, the letters can be derived by using
    the Ascii value of the random number returned.
    ex. Chr(a random no between 65 and 90) = A thru Z.
    Generate what sequences of letters and numbers you need, and then concatenate them
    together to form the final password "string"

    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions


    "CRAIG MORRIS" <CRAIG MORRIS@discussions.microsoft.com> wrote in message
    news:3D764CBB-DDC6-4A2B-B500-B598C77D279B@microsoft.com...
    >I would like to ransomise Usernames and Passwords in a database so I can
    > automatically assign them to registered users.
     

Share This Page