How to encrypt data - SQL Server 2000

From: Steph (microsoft.public.access.formscoding)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 10:43:06 -0500

I have a linked table (SQL Server) in a MS Access 2000 mdb
I have a table called tbl_users which contains a pwd field that I would like
to see encrypted when I open the table. I don't want to use the Input mask
property because everyone can remove it.

How can I encrypt that field so it will be in an unreadable format to users?