Data Environment

[kalpana]

.How to close the Data Environment's Command Object at run time?
How will the command Object of the Data Environment behaves? Whether it will
be in memory throughout the execution of the application?
MSDN does not deal Data Environment elaborately. If any one knows, please
answer.
Regards,
Kalpana.

[jbooth]

I will usually set my data environment and recordsets after I am done using them to nothing.

Set recordset = Nothing
Set database = Nothing

this seems to clear the memory. Although it all depends on how you are running your app.