[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

Access - keep users out of backend accdb

I have a split app with front end on user workstations linked to a back end accdb on a network share. I have a number of self-appointed "power users" who are circumventing the business rules in the front end by accessing the linked tables through the navigation pane. I can prevent this by deploying the app as accde, but the users all have read/write permissions on the network share folder, so they can go straight to the back end and manipulate the tables directly.

We have Office 2010/Sharepoint 2010 coming up in a few months, which will solve this problem, but until then is there a way I can prevent direct access to back end tables?
0
dgmoore1
Asked:
dgmoore1
  • 3
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
About all you can do is put a database password on the Back End ... then add the password to the Link (connection string).
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
And even if you do an MDE, users can still get to tables via the FE ... even with password, because the link connection string will need to have the password ... so, the table just 'opens up'.  So to minimize this, you can at least hide the db window and turn off the Shift Key Bypass ... which of course, can technically ...be circumvented.

But seriously, this is really a *management problem*. I have the same issue here technically. However, users know that if they do this ... there will be ramifications.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
And in case it comes up here, there have been some attempted tricks re actual permissions on folders on the shared drive an all ... but, in each case I've seen ... there was some kind of gotcha!

mx
0
 
dgmoore1Author Commented:
Looks like this is a job for a hybrid Acc 2010/Sharepoint 2010 solution.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now