Make an ODBC connection to SQL read only on the Acces side- possible?
Using ODBC, I am connecting to a SQL server table in our main business system. Is there any way that I can make this connection read only? I noticed that it is possible to make changes directly in the table. Users don't work in tables, but it still makes me leery and I would like to lock it down some how.