The database has one table, 5-6 different forms, and 3-4 queries. There are NO memo fields in the database. Forms are used by my data entry people to enter information that feeds into the one table. (Forms are the only way I can have data entry personnel enter information because there are a lot of fields.) The database is NOT a split database (I will work on splitting it soon), has shared access, no locks, and open database with record-level box checked.
Here is my problem: When more than one person tries to enter data, someone (it is never the same person) gets the error: Currently locked; couldn't save. One time the error has also been"Error 3218: Could not update; currently locked." Currently, I can only have one person enter data, which is slowing our process. Very frustrating. What should I do? Thank you for your help in advance.