Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

609 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