Encrypt column?

[Dorian]

Is there any mechanism to encrypt a column in MS Access?
I'm using 2003 version.
Thanks
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Wayne-I-M]

don't think so - you can stop people looking at the the table in the 1st
place which would be the better option

 

[Tony Toews [MVP]]

Is there any mechanism to encrypt a column in MS Access?
I'm using 2003 version.

No although you could do it using a function call in queries.

However if this kind of security is required then I'd strongly suggest
going to a product such as SQL Server. The problem with using an
Access MDB/ACCDB for such, even if encrypted, is that someone can copy
the file from the server and you'd never know about it. Then they can
take it home with them and run cracking routines against the data for
years.. Or take the MDE home and somehow reverse engineer the
encryption password and use it.

Tony