I have a database that is used by 10 people. Every time there are simultaneous use on the form (2 users using the form at the same time---either viewing or entering data) I got a message if I want to keep existing changes. How can I get rid of this message? I don't understand why message pops-up if users only view the data using the form.
2) Database located on network. Is there a way to create a copy of the database on each machine so one user don't cause work delay of second user. However, I have to make sure that all users see any entry or updates right away.