I am looking for someone to point me in the right direction regarding the best method to add security to an existing Access database application our company is using. Currently, we have a backend database that holds the data for the tables. Each user that accesses that data utilizes a front end database with all the queries and forms etc... Each user has their own individual front end database.
I want to make sure that users cannot have direct access to the tables and can only update data using forms. I have tried to utilize a workgroup approach but found that does no good since my users all have their own individual front end databases.
Can somebody direct me to a good resource on this topic? Thanks much.