Solved

Access 2010/SharePoint 2010 Hybrid app - prevent users from saving app modifications to server

Posted on 2011-03-04
5
637 Views
Last Modified: 2012-05-11
I have a code-intensive Access 2010/Sharepoint 2010 hybrid app that runs on the client. I see no practical way of preventing a knowledgeable user from opening a local copy in maintenance mode and making design modifications. Is there a way, using permissions or whatever, to prevent changes made by a user from propagating back to the server when the user saves changes? The hybrid approach is perfect for our scenario, so I don't want to use an accde.
0
Comment
Question by:dgmoore1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 6

Expert Comment

by:psv1973
ID: 35037516
Do you want users to not be able to make chnages to the sites? ( i.e. restrict their permissions to Contribute, so that they can only add data but can't change the pages)
Or do you want them to be able to create personal versions of a page whihc don't affect other users? ( -> User personalisation features)
0
 

Author Comment

by:dgmoore1
ID: 35037608
I want to ensure that, if a user manages to open and modify the accdb he opens on the client via the accdw shortcut, the changes he makes locally do not also get saved in the gold copy on the server. Currently when I, as the developer, make and save changes they are saved to the server - I want to ensure that users can't do the same thing.
0
 
LVL 6

Accepted Solution

by:
psv1973 earned 500 total points
ID: 35037637
You can do this by simply giving them Contributor rights. They will be able to addd data but then they can't make any changes to the structure of the site. Normal users should in general not have any more than Contributor rights.
0
 

Author Comment

by:dgmoore1
ID: 35037816
OK - let me test this to be sure it works.  Thanks
0
 

Author Closing Comment

by:dgmoore1
ID: 35461895
Contributor rights is the answer.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question