Look at a product called Cryptor.
>Hi,
>I want to encrypt the whole records of a table and will automatically be decrypted
>when opening a form containing the table and will be encrypted again when the form closes. so far I can only encrypt one record from a form. How to encrypt let's say 1000 records of a field once and vice versa? thank you.
>
>Regards
>
>Syah N
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer