Symptoms
Setting a Recordset’s ActiveConnection property to a recordset objectcauses either a Dr. Watson or a general protection fault (GPF) error tooccur. For example:

Set rst.ActiveConnection = rst
Resolution
Microsoft has confirmed this to be a bug in the Microsoft products listedat the beginning of this article.
This problem has been fixed in MDAC version 2.1 Service Pack 2.
Under MDAC versions 2.1 Service Pack 2 and later, you will receive the following trappable error as expected:

Run-time error ‘3001′: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.