Ya Simon, U are right. whn i tried to run the code in minute less time only the the problem come..Thanks for your information :)

One way is recursion. A quick google will provide you with many examples. Bob Ashfield Consultants Ltd

Have a look at the SYSTEM.IO namespace it does everything you need. Bob Ashfield Consultants Ltd

Check out FILEINFO as it will give you what you need. Bob Ashfield Consultants Ltd

Use this. Dim Str As String rs.Open "SELECT TestCaseName FROM [General Issue table]", oConnection Do While (rs.EOF = False) varTestCaseName_Repeat = rs.Fields(0).Value rs.MoveNext If (varTestCaseName_Repeat = rs.Fields(0)) Then Str= "UPDATE TestCaseName SET name='" & value1 & "', age=" & value2 & " WHERE name='" & rs.Fields(0) & "' And age=" & rs.Fields(1) & ";" rs.Open Str, oConnection End If Loop Ananda