encryption

[georgia51390]

Is there a way to encrypt one column of data in a table? I have a table that stores user ids and passwords, but I want the passwords to be encrypted, so that if the table is opened, the passwords cannot be seen. Could a procedure be created to do this?
Thanks so much!

 

[balves]

You could do it from VB or VBA with the XOR function:

http://support.microsoft.com/suppor...ypt data&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=VBB