Yes - agree with GuardData - closing the rocordset ought to release any locks it is holding - in some configurations of the lock- and cursor- type parameters, the rst will act like a scroll cursor, holding a lock on the current record, or even all the records, until you close it.
quote:
We did discover two ways to make this problem go away. One was to change the rsTemp.Open statement to gadoCommand.execute which eliminates the second connection
Was this not a satisfactory solution?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant