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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER