I'm in middle of a process of securing data in our database.
Would like to move all employees sensitive data into a separate table and have the columns there set as encrypted columns.
Now I am basically looking for an introduction on how to successfully use that within my Access FE application.
Was trying to follow what it says on following link
However when I ran the following view, the encrypted column was showing as null..
create view v_employees as select id, name, convert(varchar(10), decryptbykey(salary, 1, convert(varchar(30), id))) as salary from t_employees;
Thanks in advance.