How to generate a password in all the records of the field of a table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Telesphore - 25 May 2005 14:43 GMT

How to generate a password in all the records of the field of a table?

Example: tblStudent with the fields [LastName], [First name], [Street], etc.

Is it possible to generate it starting from the last name of the user?

Thank you in advance

P.S. Sorry

Reply to this Message

Alex White MCDBA MCSE - 25 May 2005 14:57 GMT

Sounds like you need an update Query

'Update tblStudent Set Password = LastName'

this will set the password to the value in the LastName field.

Signature

Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

> How to generate a password in all the records of the field of a table?
>
[quoted text clipped - 6 lines]
>
> P.S. Sorry

Reply to this Message

Rick B - 25 May 2005 15:05 GMT

No idea what you are asking. What is a 'password'? What are the rules for
it? How long can it be? What characters are valid? Will it just be random
numbers and letters?

Secondly, why are you doing this? If you wnat to use these passwords for
your Assecc application, then you don't create a table for them, you use the
built-in user-level security that comes with access. You create the
userids, passwords, and the groups to which they belong in the Tools menu.
Implementing User-level Security (ULS) is fairly complex, and I would
recommend you read, and reread the security FAQ before doing it. I'd also
recommend you make AT LEAST one backup of your database before you start.

Post back if these passwords ARE NOT for Access and you wish to share with
us how you want them defined.

Security FAQ

http://support.microsoft.com/?id=207793

The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555

Joan Wild:

www.jmwild.com/AccessSecurity.htm

Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

Signature

Rick B

> How to generate a password in all the records of the field of a table?
>
[quoted text clipped - 5 lines]
>
> P.S. Sorry

Reply to this Message

Telesphore - 25 May 2005 20:06 GMT

We need to give a password to each student, so he could consult his school
marks through our web site.

Is it possible to generate the password with MS-Access 2000 in a field
[Password] in the tblStudent?

The password could be 2 numbers and 2 letters at random.

Thank you again

> No idea what you are asking. What is a 'password'? What are the rules
> for
[quoted text clipped - 13 lines]
> Post back if these passwords ARE NOT for Access and you wish to share with
> us how you want them defined.

Joan Wild:

> www.jmwild.com/AccessSecurity.htm
>
> Lynn Trapp
>
> http://www.ltcomputerdesigns.com/Security.htm

...

> "Telesphore" ... wrote in message
>> How to generate a password in all the records of the field of a table?
[quoted text clipped - 3 lines]
>>
>> Is it possible to generate it starting from the last name of the user?

Reply to this Message

Rick B - 25 May 2005 20:44 GMT

I would recommned building an update query to update the table with the
password you want to create. You will have to build a furmula to let Access
create a random string and use that formula in the "update to:" field of
your update query.

I'd recommend you do a search for previous posts and search for "random".
You should be able to find some posts that will help you create the entry.

Signature

Rick B

> We need to give a password to each student, so he could consult his school
> marks through our web site.
[quoted text clipped - 40 lines]
> >>
> >> Is it possible to generate it starting from the last name of the user?

Reply to this Message