Solved

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

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
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 how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

828 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