Dienstag, 29. Januar 2013 14:25
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.
Dienstag, 29. Januar 2013 15:04
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)
- Als Antwort markiert Yoyo JiangMicrosoft Contingent Staff, Moderator Freitag, 8. Februar 2013 06:25
Freitag, 8. Februar 2013 09:04
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.
Freitag, 8. Februar 2013 15:39You 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.