In Access 2013 it's impossible to set readonly Linked table

Question

Hi !

I'm using an Access 2013 frontend on a Sql Server 2012 Database.

My customer only want to see the data of the database (I'll make him a few join with the datas he needed) The datas also needs to be READ-ONLY in Access. 

But no matter what I'm trying, when I edit a field with access it's updated in Sql Server. I've tryed the SQL Server Authentification with an user that has only a role as db datareader for this Database, nothing works. Even a view is editable and change the original tables . If anyone has an idea ...

This happens on every database I've tested ( even Northwind don't work to), so it's easy to find the problem. 

Greetings 

Answer 1

You could create pass-through queries instead of than linked tables. That being said, I find it hard to believe that a user with only db datareader permissions was able to perform updates. Are you certain the user wasn't inheriting greater permissions through some group to which he/she belonged?

---

Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele (no e-mails, please!)
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)

Answer 2

I have create a new user with only db datareader role for the database,it didn't work. (it was a complete new database, I change nothing in there)

That's something strange because my college try it, on some db it works , on other not.

Answer 3

You can set any forms control 'Enabled' property to NO and the 'Locked' property to YES. This will disallow editing the field. You can also set the form 'Allow Additions' property to NO to prevent new records from being added.