Thanks for the update

I did not know that. I dislike using VBA and VBScript (out of my comfort zone). What I have now seems to work ok.

If there are any problems I can point those who like working with VBA or VBScript to such an implementation. Do you have any links to such VBA /VBScript code?

If you are concerned that someone can easily read your VBA code and your salt, then you have other things to worry about. Using a .Net class only offers obscurity and we all (should) know that obscurity isn't security.

I think the problem is more with the passwords stored in a database staff table. The passwords are currently stored in the table as plain text. It is this that's needs to be addressed first. The idea of a hash algorithm being theoretically irreversible, means that someone who gains access to the VBA or C# code would only discover that the passwords are hashed by whatever algorithm is used. If a symmetric cipher is used and the key embedded in code (or somewhere else accessible) then the table's passwords can be easily decrypted.

Of course this requires that all passwords are different and are of reasonable complexity. For half the table to be filled with easily guessed passwords like 'password' will defeat any security measure. It also means that a user who forgets their password must be allowed to create a new one (or have one generated for them) as the old one cannot (in theory) be derived from the hash.

Regards Peter



On 9/03/2010 5:44 AM, Richard Carde wrote:
If all you need is something to generate an MD5 hash and nothing more, you could use an MD5 implementation directly - afterall, MD5 is MD5. There are a number of VBScript/VBA implementations to select from.

Reply via email to