Data Encryption.

[Rajmohan]

Hi,

i have a doubt on the data Encryption in MS-ACCESS 2003.I am using MS-
ACCESS 2003 as Front-end and SQL SERVER 2005 as Back-end.My scenario is below,

In MS-ACCESS 2003,whatever the data entered by the user, has to be
'Encrypted' before sending these data to sql server 2005 and also 'De-
Encrypted' before populated in the front-end(MS-ACCESS 2003).Actually i am
new to MS-ACCESS 2003.Can you please any one help me on this.

Thanks in Advance.

Rajmohan.

 

[a a r o n _ k e m p f]

uh, I believe that you can enable this by changing one setting in
Access Data Projects

under FILE, Connection, Advanced, you can just turn on 'require
encryption'

HTH

-Aaron

 

[Rajmohan via AccessMonster.com]

Thanks aaron.Can you please tell me in detail ...because i am using Sql
server 2005 as Back-end and MS-ACCESS as Frontend.Whenever the user enters
data in the form of ms-access that data has to be encrypted before sending it
to sql server 2005 and de-encrypted before populating in the form.
Awaiting for your positive reply...Thanks in advance.

uh, I believe that you can enable this by changing one setting in
Access Data Projects

under FILE, Connection, Advanced, you can just turn on 'require
encryption'

HTH

-Aaron

Hi,

[quoted text clipped - 9 lines]

Rajmohan.