Access 2007 splitting a database
Posted on 2009-07-14
I have a database which I have made copies of and have been splitting. There will be more than 10 people who will use this database at any one time. The users need to be able to input and save data.
I have experimented with two people simultaneously usine the same front end. Although we could both access forms at the same time and create new records as soon as we tried to save it would not let both of us.
I then made a copy of the front end so we both had one each. This time it allowed us to save however what I saved on my front end did not appear on the other users front end.
I need to be able to have multiple using the database at once, being able to save and view reports at the same time and have any changes made by one user show up on all other users front ends once it is saved. Can anyone help me?