How to use sha512 hashing

[perlfan]

How to use sha hashing

Hi there - I'd like to access data that I use in Access also via browser/php. For the login, I'd like to use a secure encryption method for passwords etc. MD5 seems to be unsecure - so now I'd like to implement sha encryption via Access VBA and in the browser/php. Has someone advice for implmenting this in Access??
Thanks! FRANK

 

[plog]

I don't think this is an Access issue, this can be achieved via php. Check out the php hash function:

http://php.net/manual/en/function.hash.php

You get the sha512 hash and you store that in the database. The database doesn't do a thing, just stores whatever text you send it--php does the encryption work.

 

[perlfan]

Hm, I think you got me wrong. I want to use the same method in Access/VBA for encryption as I do in the browser with PHP. This is why I'd like to know if someone can help me to implement SHA2 etc. in Access/VBA.

 

[Galaxiom]

Worrying about encryption while using Access as the backend is like putting a steel lock on a cardboard box.

Use SQL Server as the Backend. It has SHA hashing built in.

 

[The_Doc_Man]

Try articles via the great Google-brain on the topic if "Windows Security API" to see how you can use the built-in hashing supplied with Windows. I've never used it myself because it has never been worth the effort to me.