I loaded your code in VB 6.0, but it does not recognize several lines. I couldn't run the code. Also, I have foreign key to the related table. 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.

Thanks,

Chao-Yong