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.