Password hiding in Access, Can this be done?

[Pradeep]

Hello,

We have an access application which connects to various databases like
Sybase, Oracle etc. It also performs functions like FTPing files to a
location etc. Now the problem is the developers have access to the password
since they have to specify them in the code. The users do not want to key in
and also want a method of mantaining the passwords such that the developers
cannot read it.

Is this possible with MS Access, can we do this?

Please suggest.

Thanks,

Pradeep

 

[Terry Kreft]

If your programmers can't think how to get around this then you probably
need new programmers.

One way would be:-
You provide a store where the passwords are kept (encrypted)
You provide a form which reads the store so the users can review and amend
them.
One of the user amendable items you provide is the key for the encryption
algorithm.

The store can be
Database table
Ini file
Text File
Database properties
Registry
Anything else you can think of...

You can get encryption algorithms from the net.

 

[David F Cox]

It is possible. Ask the developers. They are being paid to program a secure
system. Mention that you will want to change the passwords from time to
time.