Locks not releasing
Perhaps someone can assist .. I am running a MSACCESS DB - using ODBC with MySql underneath. I have MANY QUERIES that update a row of data within the MySql environment baes on a single record in an ACCESS Table that has a unique key that joins to the unique key of the MySql Table .. these all work well.
As soon as the ACCESS Table has a population of rows more than 1 .. and all rows still have unique keys .. the first iteration of the UPDATE QUERY work in ACCESS - HOWEVER the LOCKS for those rows are not released and the next time I run the same ACCESS Quesry .. the update fails -- because of record locks ??
Here is a sample of the SQL within the QUERY DEF of the Microsoft DB.
UPDATE Tbl_Local_cc_incident_notes INNER JOIN dbo_cc_incident_notes
ON Tbl_Local_cc_incident_notes.CC_Incident_Note_id = dbo_cc_incident_notes.CC_Incident_Note_id SET dbo_cc_incident_notes.CC_Incident_note = [Tbl_Local_cc_incident_notes].[CC_Incident_note];
Subject
Written By
Posted
Locks not releasing
May 20, 2016 02:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.