Dear all,

I used adodc to navigate through a database but when I close the program , the lock file which is created at the time of opening database won't be deleted and it would remain as the connection to database isn't closed. I tested different codes to close the database but it wasn't successful such as adodc1.recordset.close.

Thank you,
Azadeh

Hi,

Try this out.

1. Add a reference to Microsoft ActiveX Data Objects 2.0 (or higher) Library.

2. declare a object of the connection object and the recordset.

3. Add the code before closing the application

lets say
Conn is the object for Connection
Rs is the object for Recordset

If Conn.State = adStateOpen Then
   Conn.Close
End if

If Rs.State = adStateOpen Then
   Rs.Close
End if

Hope this helps,

Lalit
Life Means More...;)