Disconnected Recordset Opening and Closing problem.
-
Hi, I am working with Disconnected Recordsets in a Component Function.I am passing the Recordset pointer from the Server to Client.There is no problem here.However , when I run the client for the First Time the Connection and Recordset objects are opened and I can get the records at the client(The server maintains these Records in MS Access DB).When I run the client for the second time and so on I get the COM error that "The application requested an operation which cannot be performed on an Object which is already open ".The error is due to Recordset opening at the start of the function .But, I am closing the REcordset at the client side. How should I open and close the REcordset in that case to avoid this error ? Thanx in advance for the help . Regards, yamini