Data Encryption Issues with ADP and SQL2005 EagleRed[ at ]HighFlyingBirds.com 24.09.2006 17:01:02 I am new to the arena of Access 2003 and ADP. I am converting an Access DB and application to ADP and SQL 2005. As a test I created a DB on the SQL 2005 remote (not on my LAN) server and then created a new ADP in Access that links to it. I see the tables OK and can operate on them just fine so far. I have opened the tables while looking at the network traffic with Ethereal and it seems the data is encrypted as it transfers from the server to my workstation. The target application contains sensitive information (social security numbers(SSNs) and credit card data). Here are my questions. 1. Is the transfer of data, login passwords and table contents, normally encrypted as a matter of design for an ADP? If so, are there any special caveats? 2. How is the issue of data storage of sensitive information, like SSNs, to be managed in the context of an ADP? SQL 2005 has functions like, EncryptByKey, to manage encyption. Thanks for your help. Eagle