How to Disable Editing SQL Server Linked Recordsets and Encrypt it?

[accesser2003]

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

 

[accesser2003]

So What should I do???
If any one can advise

 

[Banana]

Pat, would it also work to just create a User Level Security but only grant the default Admin user full permission to forms only while denying all permissions for any other objects, thus partially securing the database without requiring a logon for the front end itself?

 

[Banana]

Thanks for that information about QueryDefs- that would be an important consideration.

You're right about that security of SQL server has to be done within that environment, and not by Jet's mechanism. I had implicitly assumed it was already secured, and he just wanted to prevent linked access to the tables using the same credential for the front-end to log in.