I am thinking of using access at work to help share information. We have anywhere from 2-15 people that will have access at any given time. We will be using this to store 1) phone directories 2)Employe Contact info 3)Staff Information 4) documents and a few other key items. Each will have its own database. I was thinking of using the dbase splitting feature but am not completely clear on on it works.
If I understand it correctly, it creates a front end copy of the database which is distributed to each user, if the user is running off the front end copy, and makes a change or updates information is that change saved to the back end or only the front end copy?
I will need each user to be able to edit/change data in any of the data tables and those changes be available to any of the other users. So I don't know if splitting the database feature is what I want.
Thanks for your help in advance.