Hi, I have not been able to find this anywhere on the net, but we have a SQL security question.
Hopefully I'll explain this simply enough.
(environment: SQL Server 2010, Windows 7, Access 2007)
Using 'Nameless' DSN connections to an SQL server (that is at 'connection' time we pass along the credentials to connect to an SQL server table by table, with server, db, user ID and pswd credentials for each connnection), we have defined an id using "Select" only rights (or read-only). (We're using SQL Server Authentication, not Windows Authentication).
Through any other interface it does appear that updates are not allowed. However, from Access, if the user has a copy of Access, then they can create an action query, and they appear to work. Is there some kind of setting that we're missing on the SQL database, or within Access that enforces the access rights of that id in question? This is not behavior I would expect.
thank you.