Write Conflict

D

Darach

Hi

I am developing an Access 2003 database. It is split into a front end and
back end and will need to be accessed concurrently by multiple users.

Part of the functionality of the database is to allow users to enter
information, often in large memo fields which could potentially be accessed
by more than one user. I am handling the editing of records within data
bound forms in vba code - i.e. when a user accesses a record I update a flag
in the record to indicate it is being edited, then if another user accesses
the record it will allow them to view all the information for the record, but
all of the data fields will be locked, preventing the user making any
changes.

I am getting a problem whereby I am intermittently getting 'Write Conflict'
errors when I close the form, when more than one user has accessed the
database. If I choose the 'Save Record' option then the data is saved as I
would expect it to be, however I would rather these messages did not appear.
Is there any way to surpress these messages?

Thanks

Darach
 
Top