Using Access 2013 or Sharepoint 2013 is it possible to give someone access to data entry forms that work with a back end database whether Access database or Sharepoint SQL.
But from everything I've look at I can't find away to separate someone from entering data and viewing all data?
For example in Access even if I split the database to a back end, it still has all the tables linked, and fully accessible from the "front end" this seems to be needed to allow Write access, it seems that you can have no access, read only access and Read/Write access but no write only access (this might be where I am wrong).
I don't want the people entering data to see the back end data (regardless if they are on Sharepoint or in access) and certainly do not want them to be able to modify the database directly (they should only be able to enter data via a form that can be validated before entered.)
Now I come from a Windows Forms and ASP.NET MVC background. I am used to hosting a SQL server and simply not writing code that pulls data from the database, and if I did I could set parameters on what data they could access. I could also set up server side validation based on users and groups.
I can't seem to find any documentation on how to do this in either Access or on Sharepoint. I have read every article I could find on these topics via google and Support.Office.com for starters:
Introduction to integrating data between Access and a SharePoint site
Ways to share an Access desktop database
and a multitude of other articles both on technet and various third party sites. While some do touch base on user access rights, they seem to allow only access to a specific site or data base not parts of, as my needs are allow access to a way to enter data but not access to the data.
The client I am working with is addiment on using Access and Sharepoint. And before telling them I can't limit a user to data entry only, I wanted to check here first.
Aucun commentaire:
Enregistrer un commentaire