>You need a finaly and oConnection.Close() there. So no matter good or bad it's terminated.<Nope ... I disagree. What the DataAdapter.Fill() does in reality is leave the connection in the state it was in. So, if it was already open, it will still be open after the .Fill(). If it wasn't open, the .Fill() opens and then closes it. Therefore, you'd possibly only want to close it in an error situation.
~~Bonnie
>>Probably all you need to do is to just make sure you close your connection in your catch:
>>
>> Catch loError As Exception
>> oApp.cError = oApp.ErrorSetup(loError, oApp.Debug(cSQL))
>> oConnection.Close()
>> End Try
>>
>>
>>~~Bonnie
>