record lock error opening form with ACCESS

[ochssk]

I recently installed mySQL version 4 and ODBC version 3.51. I transfered my tables from ACCESS to mySQL and am using ACCESS for the front end. Everything is working pretty well except I cannot open a form with link criteria. I get an ODBC error saying unable to lock all records. I've placed primary keys and timestamps in all my tables and installed the latest jet and mdac. I am on Windows 2000 using ACCESS 2000 and mySQL is on a Redhat 8.0 system.

Below is the code I am using to try to open the form:

Private Sub viewlog_btn_Click()
On Error GoTo Err_viewlog_btn_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmMonitorLog"

stLinkCriteria = "[lngIDSite]=" & Me![lngIDSite]
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly

Exit_viewlog_btn_Click:
Exit Sub

Err_viewlog_btn_Click:
MsgBox Err.Description
Resume Exit_viewlog_btn_Click

End Sub


Any help is appreciated. Thanks

Steve