Does anyone have any insight into run-time error 3707?
Text is: "The application cannot change the ActiveConnection property of a recordset object with a Command object as its source"
I've searched MS but alas - no useful information.
The odd thing about this error is that it occurs in an MTS object that is deallocating memory (set x = nothing) AFTER it has performed correctly. Oddly enough if I change the value of one of the parameters I'm passing to the function it works. The value I'm passing is generic and has no real effect on the call!!!!??
This function has been working all along without any changes - suddenly it returns this error. Any clues?
Note: I suspect the error number/desc may be bogus
Thanks,
Vince
