Access - keep users out of backend accdb
Posted on 2011-10-24
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?