by Hi,
If I try to delete a record using a DBGrid when the record contains one
or more empty field the delete is aborted and the following message
appears:-
"Microsoft Jet Database Engine has stopped the process because the data
has been changed by another user".
There are no other users.
I beleive that there is a mismatch between VB and the database when
comparing NULLs and that because the values appear different VB assumes
the record has been changed by another user.
An answer is to set all empty values to zero and update the database
(doesn't work with dates!) - I do this on Select Change event (as the
user must select the record before deletion).
I have not found anything in MSDN, books on line etc to overcome this,
any ideas most welcome.
Cheers,
Peter.