MySQL Forums
Forum List  »  Microsoft Access

Lock wait time exceeded
Posted by: Tim Dodge
Date: February 28, 2005 10:44AM

I have run into the following error message:
[MySQL][ODBC 3.51 Driver][mysqld-4.1.9-nt] Lock wait timeout exceeded. try restarting transaction (#1205),

while I am trying to paste data from an Access table to a mySQL table. I am currently going thru a transition to a mySQL backend. I can see the data in the mySQL table from Access. I was able to move some of the data into the table prior to getting this message, and was able to complete the data transfer on 2 other tables prior to this.

I can edit/delete data already in the table.

Any suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Lock wait time exceeded
4671
February 28, 2005 10:44AM


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.