Hi everyone!

We are having a problem that we were wondering if anyone could answer the "Why this is happening"? and "What options are there"? questions.

Our problem is that a client side ADO Recordset attached to a public object or as a public object loses the connection and state reverts to 0 when trying to access it from a different form or method than where it was instantiated. Is this normal or are we doing something wrong?

We don't want to have to set up a new connection and reopen everytime we need to access the recordset.

Any insight would be greatly appreciated!