Search results

From the article: If you type "Let's eat" into the suggested online calculator you will not get the hash that the author claims. However, if you copy and paste "Let's eat" from the article into the calculator it will return the promised hash. The author gives no explanation for this.

Thank you Doc_Man. I will study this right now.

No. I took the salt out of my process for now until I get the basic hash to work. It shouldn't need salt, correct? Salt just adds another layer of security. I will add that back in once I get the basic hash to work.

I replaced @pPassword with 'joseph' in my sproc and got the hash that all of the online converters agree is correct. This means that I cannot trust the passing of the string into the @pPassword parameter of my SqlServer sproc. So, sonic8, your guess is correct. This is most disappointing. What...

Okay. I have everything in my interface working now thanks to all of you! My problem now is that the SHA_512 hash returned by Sql Server is completely different than the SHA_512 hash returned by the online hash calculators. Example: For the string 'joseph' Both https://sha512.online/ and...

This is exactly what I needed to see! I'll take it from here. Thank you to everyone for your time and advise!

I appreciate your time and advice with this sonic8! It is necessary to validate the user again in the app to ensure that he has been permitted access to this specific Access application. Are you suggesting that a login screen along with its validation process is not necessary when using...

Yes. But how is that relevant? I do know how to compute the hash. That's how I was able to encrypt it. But I don't understand how to validate it from my Access front end. I downloaded your bas file (thank you for making this available!) but I must believe that there must be a way simpler way to...

dbGuy - No. They are authenticated through WIndows. sonic8 - How do I ?

Not sure I understand your question DBguy. I need to validate the password that the user enters in the front end interface of my MS Access program - and I don't know how to do that. The password is encrypted SHA2_512 in a back end SqlServer table.

plog - Apparently I use the wrong phraseology. I don't want to decrypt the encrypted password. I just want to validate it. How do I do that? Do I use VBA in my Login form? Is this done on the Access side or the Sql Server side? Can you please clarify?

I finally succeeded in encrypting the user passwords in my back end Sql Server database Login table using SHA2_512. Can someone please point me in the right direction tp decrypt it via my front end Access interface? What would the query look like? Below is what the data in the linked Sql Server...

I'm not hearing of any error messages - but I remoted into the user's machine and saw that something was definitely hogging memory. I'll look more deeply into this on Friday. Thanks for your help!

Yes. Of course.

Thank you everyone for your input. Much appreciated. Why would this happen in only one of about 20 cases. It's so intermittent. Could it have to do with a memory issue on the individual person's computer? We have a client-server environment where Access (and everything else) is being served to...

I just read in this article that Adobe no longer support MS Access pdf exports. I have many Access interfaces from which I export reports as PDFs using the following code: DoCmd.OutputTo acOutputReport, "r_Note", acFormatPDF, strFolder & "\" & OutputFileName, False, , , acExportQualityPrint I...

I found the problem. The data, once entered, is stored in an SqlServer table. Each of the fields in this table has a char(1) datatype - except the field with the problem. That field had a char(10) datatype. I changed it to char(1) and now the problem is solved. I appreciate your time GPGeorge...

The data are values in a value list. I just copied this value list from another combo box since they all contain the same values. Problem still exists. I then deleted the entire combo box and recreated it. Problem still exists. This is most definitely an interesting problem.

Yes the properties are identical. As a matter of fact they are copies of each other. They just have different names.