Solved

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

Posted on 2011-03-04
5
613 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views 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 Microsoft Access…
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now