>I loaded your code in VB 6.0, but it does not recognize several lines. I couldn't run the code.
Did you save the lines that I have sent in a .frm file and the open it in VB.

>I was reading SQL reference book over the weekend. It says that only one table can be updated at time. I don't know if that is the problem.
So why was I able?

Is it an Access database, if so send me a small database with a small portion of your (only what is needed to reproduce the error) and I will check it.