I recently just migrated my back-end end tables from Access to SQL serves but still using the Access front-end. In the process of doing so, I decided to encrypt the Password column (which stores user passwords when accessing the database) to one of my back-end tables in SQL. After linking that back-end table to my Access front end, users are now unable to access the database due to Access not reading the Password encrypted data.
Is there a way to resolve this issue?