How can more than one user utilize a database when the file is stored on a network. Obviously, with one person entering data, others would have read-only access. My situation is that I need to warn the second person in that they have read-only access. Most users of my database are PC novices and they just type away only for the info to be lost when they leave.
Also, there is some corrupted data in the main table. Info has been entered in appropriately, but on the next day, chinese characters have replaced some data in certain fields. The characters are corrupted on only a few records, not all. And in other fields, data is replaced by duplicate data in previous fields.
I know this sounds ominous, but it is what is happening. I've looked into the properties of each field and they are correct. I am most perplexed as to why it corrupts data in some records and not all.