dbTalk Databases Forums  

R: Re: odbc - mysql - database engine stopped the process ..

comp.databases.ms-access comp.databases.ms-access


Discuss R: Re: odbc - mysql - database engine stopped the process .. in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
informatix
 
Posts: n/a

Default R: Re: odbc - mysql - database engine stopped the process .. - 05-18-2011 , 10:09 AM






i try the delete directly on the linked table
in this moment i have on the db one record with this problem, i taking it in order to do test on it: with a simple delete command from the linked table i obtain the error message (the on indicated on my first post).

this record was written by a vba code through openrecordset() and .edit .update operation that involve date,text and various conversion : maybe some error data conversion ?

Reply With Quote
  #2  
Old   
The Frog
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.