Create read-only MS Access connection to MS SQL Server (using full-rights SQL login)
Posted on 2015-01-15
I would like to give an employee the ability to run SELECT queries w/ Access to a linked SQL Server database, but I don't want her to be able to edit any of the data.
I know I could setup a read-only user in SQL Server Management, and use Access to connect through that user, but we're in a situation where we can't create another user. We're forced to use an existing SQL Server user login that has full rights. It's dumb, but our database is managed remotely by a 3rd party, and they want to charge an outrageous fee for maintenance and support of additional logins.
Is there another way I can prohibit the user from editing the SQL Server data using Access?