Roman B. said:
Anyone know how to suppress a WRITE CONFLICT message box from showing in
an
access DB? We know what is causing it to show up but want to keep the
message
from popping up, because it really isn't causing a problem.
The above is contradiction in logic. If you know what is causing the
problem, then you would fix this. That message means that some other person
(or code that you run) has modified the record, and if you save changes,
then some data will be lost...
I cannot in any good standing recommend that you ignore this message. I
would strongly suggest that you fix the code....
If you have a form sitting on one record, and you
a) launch another form that might edit the data
or
b) run some sql or update code that does NOT USE the forms
controls to modify the data,
Then, simply FORCE a disk write of the current form to flush out all changes
to disk, and THEN open that other form (a), or then run that code (b).
Simply put a
me.Refresh *right* before you run the offending code that modifies the data
(or opens another form that might modify the data). That way, then you (or
your code) returns to the form...there is not pending disk writes...and thus
no write conflict that can occur...
I can't imagine you are in a position to simply ignore the message, as that
message means some of your data is about to get overwrite and not saved.....