thanks for the response Andy.I sorted out the problem tho.I was doing 2 updatebatch routines from 2 diffrent recordsets which seemd to cause the connection failure.I changed my table...