Multi-User Access Database Management HELP!
Posted on 2014-03-19
I have created an Access 2007 database that we are using to manage employee vacation time. When I created it the intention was to have a max of 2 users in it at one time. I was asked to open it up to management which forced me to split the DB.
Among a million little issues that I am having the biggest is managing frontend copies.
1) I send out specific instructions to go to a folder copy and paste the frontend to their desktop and it never fails. There’s always one that rode the short bus. This is causing me issues when I make updates. Suggestions?
2) I sometimes want to compact and repair the backend but with so many people connected through their back ends it locks everything up. Is there something I can do here? I created a feature that kicks everyone out of the frontend when I change a value in a table which works fine with one exception. If the user has the database open then walks away from their desk and locks their PC then it won’t kick them off until they unlock their PC.
3) Lastly, since I have a team of Admins of about 2 or 3 that need access to the different queries and tables in the backend that are not linked on the frontend should I make another copy or would it be okay to put all of my original queries, forms and such back on the backend and work from there?
Any assistance with this would be much appreciated.