MS Access to MySQL Linked Table via ODBC >> Is there any way to decrypt columns

I have a MS Access Frontend to a MySQL DB via a linked table this was working well but recently implemented MySQL encryption for a new security concern.开发者_运维技巧

Do you know any way to decrypt the Fields using the Linked table interface?

A workaround would to create a view on MySQL. This view could have AES_DECRYPT in Select. This way Access would see decrypted data.