can't unlock a "locked" table

from a newbie.
Script language is ColdFusion on windows 2003
I have a dbase - MySQL 5 default table type where one table keeps
getting "locked" or perhaps unusable is a better term.
I can write to it but that is all.

Even using Query Browser I am not able to edit/or delete  records. If I
drop the old table and create a new one all is well ( in Query Browser)
until I add or modify new records.

Here are the 2 queries I am using. Can any one see a cause in the
coding. I am not explicitly locking/unlocking - just a barebones write
to the BD.

Update existing record:

Update Equipinv.loaned Set loaned.returned = 'vartext1' where
((TrackNum = varInt1) and (loaned.returned = "0"))


Add new record

INSERT INTO EQUIPINV.loaned (loaned.trackNum, loaned.to,loaned.out,
loaned.due,loaned.student,loaned.returned) 
VALUES (varInt2,'varText2', 'varText3', 'varText4',
varInt3,'varText5')


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]