I know that three main objects with ADO object modal are connection, command and recordset, and once their jobs are done, these objects should be set to nothing to release memory. My question is to go to connection.

1) what is difference between set connection object to nothing(ie, set connection = nothing ) and close a connection (ie, connection.close).

2) if a connection(through network) isnot yet closed, but all ADO objects are set to nothing, what is a picture to network load?. if a program is closed without closing the connection, what is going to happen to the connection. For a program with one database, only One connection is needed no matter how many queries you want to apply. is that true?

3)I heared about "Optimistic locking" and "Pessimistic locking", how to apply them in ADO

Someone please give me a free lesson , Thanks

[This message has been edited by Winla (edited 02-18-2000).]