Protecting Linked SQL Tables (2000)

[AndrewKKWalker]

I have some tables in an SQL 2005 database linked to an Access .mdb
The connection for the links ONLY allows SELECT, NOT Update, Delete or Insert.
This is set up on the SQL Login that is used for the Connection.
However, despite this, I can still edit and update the data in the linked tables using Access.
If I use the same login on SQL directly I cannot.
Have I missed something here.
We do NOT want to use Access's own security for this.

[AndrewKKWalker]

Still not sure about the tables.
However, I found a solution...
I used Views instead of tables and set the Properties of the Views
to be SELECT only (which was the same as the tables).
The views are read only (as I expected), but the tables remain editable.
So I have removed the table links and kept the view links.

I could I guess also have used pass through queries instead.
They may have been slightly quicker to retrieve data but have not tested this option.

Still interested in if the table link option is workable.