Thanks John,

Maybe you can provide some hints to improve what I am trying to do.

I started a new thread called '3 tier, MTS, Ado, Oracle' to exand the scope.

Thank,

Michael



>Hi Michael...
>
>When doing middle-tier work, from a performance standpoint - and to work with MTS - should that day arrive - you will want a stateless model. Right now, the way things are set up, you need to continually query to object's interface to get data. Another approach is to use a method that returns an ADO recordset to the client. Now, all work can be done at the client - without the need to make continual round-trip calls to the server object. The only time you would need the services of the server object would be when and update would have to occur.
>
>Just another approach...