Re: R: Re: odbc - mysql - database engine stopped the process .. -
05-19-2011
, 05:37 AM
OK, so if I understand you correctly you have a linked table, and you
are opening this linked table by double clicking on it, and trying to
delete the record from there.
Have you defined your primary key / unique key for the table?
It seems to me that something is not quite right here. I am guessing
that your recordset is still open at the same time as you are trying
to edit / delete the records directly from the table. Having both the
recordset open on the exact same record you are trying to delete from
another 'process' will cause an error because the record is locked by
one or the other. My suggestion in this case is to do the delete from
the same recordset that you are editing from.
Post some code if you like and show us how you are doing this. It may
be simply a matter of some small tweaks in the approach you are using.
Maybe I have not understood you correctly? Let me know.
Cheers
The Frog |