Encrypting a feild

Question

I have an split Access database (mdb) that has just been moved to Access 2010 but kept as an mdb. In the main table there is a field that holds a Social Security Number. The new head of IT is concerned that this field has just been sitting out there on the network (rightly so) and wants to encrypt it. I have no experience with working with it at that level. Can anyone tell me if it is possible in either Access 2003 or Access 2010, mdb or accdb to do this? If so, can you tell me how? The field is not an ID field and only shows up on the form and possibly on a report.

I was trying to post this on the Access forum but it forced me into the SQL Server Security. Currently the backend is not in SQL, just Access and I am not sure about the possibility of moving it.

Thanks

---

Terri

Answer 1

Hi,

If you can up-size the MS Access to SQL Server then you may have couple of options to encrypt data (TDE or column encryption). Until you are in Access the MS Access forum members may provide much better answer.

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog