I am working on an application that was handed to me and there seems to be issues when there are multiple users entering data at the same time.

It appears that if two people are trying to save at the same time they have some issues. One that seems most common is ERROR #24 ALIAS NAME IS ALREADY IN USE. Another that occurs is ERROR #114 iNDEX DOES NOT MATCH THE TABLE. dELETE THE INDEX FILE AND RE-CREATE THE INDEX.

What is the best way to handle a multi-user environment?

Thank you