Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to Encrypt the SQL Server data

Author  Topic 

accesser2003
Starting Member

14 Posts

Posted - 2008-07-05 : 06:52:40
I am developing a system using the MS Access 2003 tool. The backend is SQL Server MSDE2000.

I want:

- Disable the user from directly editing the SQL Server Linked tables objects in the database window if he open these tables in the Datasheet view. He should edit it only through the MS Access forms.

- When the user opens these linked tables objects in the Datasheet view, I want him to see only the encrypted data as # symbols instead of seeing the real data.

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-05 : 23:39:01
Sounds you need third party tools.
Go to Top of Page

accesser2003
Starting Member

14 Posts

Posted - 2008-07-07 : 17:52:33
Is there any people who can help me.

Please...
Go to Top of Page
   

- Advertisement -