?
Solved

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

Posted on 2011-03-04
5
Medium Priority
?
647 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 2000 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

771 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