Solved: Password Encryption

[Meagon]

Hello,

Does anyone now of a way to enctrypt a string in VBA?

Thkx,

Meagon

[OBP]

Why would you want to do that in Access when Access's Security will do it for you?

[Meagon]

How exactly do i do that?

[OBP]

You Secure the Database with the Security Wizard. Everybody who uses the database has to log on with a user ID and Password. They can have differing levels of access to records, tables, queries, forms, reports and macros.
Look under Tools>Security on the Main Menu.

[Meagon]

Ok, i get it.:thumb

But that isn't what i wanted. :think:
I need to create a user account table with local (user / pass) and on-line (user / webservices tokent) Autentication.
I need a password encryption like this one http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemsecuritycryptographymd5cryptoserviceproviderclasstopic.asp but for VBA use.

[OBP]

Have you tried the Microsoft VB version in the VB Editor?

[Meagon]

Yes, it doesn't "compile":dunno

[OBP]

Meagon, sorry I couldn't help.
I did have a look at the Access Reference Library and found one reference called cryptext which is a free text encryption program, but I don't know anything about it or whether it can be used with Access, other than it is in the reference library and it is a free download.

[Meagon]

Thkx anyway OBP!

I have a litle bit more info now, i think i need to create a class module with the encryption algorithm... well.. gonna try it out.

Thkx!:thumb