Write conflicts usually happen when the form you are using has 'no record
locks' set. With this setting you are banking on the fact that two users
will never try to edit the same record at the same time. You should have
form set to lock on 'edited record' and also have error checking written
within the code against the form.
Another issue is to make sure that 'ALL USERS have write privileges to the
folder where the database resides. I they don't then they can't make
changes/edits to the database and therefore can't write to the database.
Many admins who are not familiar with Access will make this error; this is
assuming that your database resides on a network server. If it does not,
then you must make sure that 'ALL USERS' have read/write/modify Shared
privileges.
Having said the latter. If you are using a shared folder on a non-server
type machine (workstation) that another person uses as their personal
computer, you are begging for trouble, possible corruption of your database.
Sometimes the corruption is permanent. If this last sentence has gotten your
attention, then I have done my job. Be sure you back up your database often
if you are not using your database in a back-end/front-end setup.
