Access Projects & Encryption

[GlendaFreeman]

I am using an Access Project as a front-end client to a SQL Server database. I have implemented encryption in the database using functions that encrypt/decrypt the data. Problem is, when I create a form in access that uses these functions to retrieve the data in decrypted form, Access won't allow the texboxes to be editable. Apparently, if the record source for a form is a stored procedure or function, the form is un-editable, but surely this doesn't make sense?

Please, please, does anyone know how to get this working?

Thanks!

 

[ReAn]

If the control source itself is the function, it cannot push the data back through the controlling function to reproduce an encrypted value to update.

So, you need to go an alternate method.

Have the form set the value on load with code and then have the text box set the encrypted text to where it should be on the OnChange event so that when you change the text, it'll update the encrypted data.