Hi guys,
I have an Access database built for a hotline system. I want to put the file on an internal shared network so everyone can access the file. However, sometimes, when more than one person answers the phone at once, the file will be opened and edited by more than one user. I tried splitting the database and only shared the front end (including a form to input data) to the other users. However, when more than one person opened the front end file, there was still an error message popped up saying that another user was opening the file and all the edits might not be saved. There are only 10 people in the network so we don't want to purchase any other network. Is there anyway I can make it work for everyone in the network?
Thank you very much.