Is it a good idea to save the users' passords in a .MDB file?

[Guest]

Dear All,
Newbie to Access .MDB
I am trying to create a VB6 form for users to change their log-in password
if they want to. I am not sure if it is possible to save the passwords to a
..MDB file with encryption so that the actual characters of the password do
not show in case some one opens the .MDB file.
Please advise me if this is possible/safe or if you recommend a different
root.
Thanks very much for any comments in advance.
DORI

 

[Tony Toews [MVP]]

I am trying to create a VB6 form for users to change their log-in password
if they want to.

What kind of log-in password?

I am not sure if it is possible to save the passwords to a
.MDB file with encryption so that the actual characters of the password do
not show in case some one opens the .MDB file.

There is a crypto API from Microsoft. Do a search using keywords
such as CryptAcquireContext, CryptCreateHash, CryptHashData.
CryptDeriveKey using advapi32.dll.

Note that you will really need to do your homework on this issue so as
to avoid legal liability.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

Hi Tony,
Thanks for your comments. I will search those keywords.
Regarding the password, the users are assigned a temporary password to open
the vb6 application. When they enter their temporary password for the first
time, the program will ask them to create their own password (5-20 combined
letters and numbers). Then, the new password is being saved to a .mdb file
using a datarecord control which the vb6 will read and write the password to
and from.
Thanks again,
DORI

 

[Tony Toews [MVP]]

Regarding the password, the users are assigned a temporary password to open
the vb6 application. When they enter their temporary password for the first
time, the program will ask them to create their own password (5-20 combined
letters and numbers). Then, the new password is being saved to a .mdb file
using a datarecord control which the vb6 will read and write the password to
and from.

So this password then is for using the app?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/