Decrypt

[David]

Hello,

Does anybody know of a way to decrypt a SQL 2005 data column from within
Access, using ODBC to connect to the SQL database?

Thanks.

 

[aid]

Hello,

Does anybody know of a way to decrypt a SQL 2005 data column from within
Access, using ODBC to connect to the SQL database?

Thanks.

 

[Tom van Stiphout]

On Mon, 6 Jul 2009 05:48:01 -0700, David

Encryption can be done so many ways you should really be more
specific.
Also, how are the other apps decrypting this data?

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

Hello,

Does anybody know of a way to decrypt a SQL 2005 data column from within
Access, using ODBC to connect to the SQL database?

Thanks.

Your best bet would probably be to create a View or (more likely) a Stored
Procedure in SQL, and use ODBC to link to *that*.