Access - keep users out of backend accdb

Posted on 2011-10-24
Last Modified: 2012-05-12
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?
Question by:dgmoore1
    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)
    About all you can do is put a database password on the Back End ... then add the password to the Link (connection string).
    LVL 75

    Accepted Solution

    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 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.

    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)
    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!


    Author Closing Comment

    Looks like this is a job for a hybrid Acc 2010/Sharepoint 2010 solution.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now