Decrypting a certain field

Question

0.00/5 (No votes)

See more:

Hi all, i want to know how to decrypt a certain field in ms access from a sql linked table. Why? because I need to build a customized report since the reports are not available inside our current application. Thank you.

Posted 27-Oct-15 1:04am

Member 12090851

Add a Solution

Comments

AnvilRanger 27-Oct-15 8:15am

Did your application encrypt the data in the field? If not you are going to need to know the methods for encryption, AES, DES, Triple DES, Blowfish, etc. Secondly you will need to know the key.

Member 12090851 27-Oct-15 11:55am

Our HRIS Dept give me this

" select dbo.SF131412(ThrmEmpSalaryParam.Salary,'D52AAB61C1FAAEB137D30CDF1ACF58D4E6AC4FBC34DD5686','10001010101001010010') AS Gaji
from ThrmEmpSalaryParam "

However when I paste it on my Query's sql view, it came with a message and nothing can be shown. I'm not a veteran programmer, so when you asked me about the encryption methode. I'm spechless, my apology :D

AnvilRanger 27-Oct-15 13:11pm

There is no need to apologize. The subject of data encryption is vast and very few people are experts. Because you mention HRIS and from that select statement that you are trying to pull some data from an HR or Employee system. What they have give you appears to be a SQL function, as to what is does I cannot tell.

But I would guess that it is supposed to decrypt that field and return that value you need. I would suggest that you contact your HRIS department to ask about the function.

Member 12090851 28-Oct-15 22:46pm

Yes, it should supposed to decrypt the field. However I think that function can only work on SQL Server not in MS Access Query. The guys from HRIS still haven't got the answer I'm waiting for. That's why i ask how to decrypt a certain field in MS Access. I thought that it would be kind of similar SQL syntaxes.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)