Hi!
Well, connecting to the server again to go online takes time for connecting only. There are no other performance hits when working with disconnected recordsets.
>A quick question about disconnected record sets..
>
>
> **Disconnect Cursor
> oRecordSet.ActiveConnection = NULL
> **make Change
> oRecordSet.fields("moc001").value='ass'
>
>
>
>At the point when one disconnects a recordset is it usual to release the connection and restablish it? Isn't there some performance concerns here?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.