Okay, so I have a VB6 application that is using "disconnected ADO
recordsets" to store and process data. It works fine on a ton of
computers, but I have a new client that can't get the application to
run. Plus this problem is occuring on two different computers at the
client location.
My code is basically as follows...
>> Dim rsResult As ADODB.Recordset 'dim variable
>> Set rsResult = New ADODB.Recordset 'create new
recordset
>> rsResult.Fields.Append "RecID", adInteger 'append fields to
recordset
>> rsResult.CursorLocation = adUseClient 'set the cursor
location for disconnected recordset
>> rsResult.CursorType = adOpenStatic 'set the cursor
type for disconnected recordset
>> rsResult.Open
'open the recordset
I get an error "429 ActiveX Component can't create object".
The odd part is that I do NOT get the error on the "Set rsResult = New
ADODB.Recordset" line.
I get the error on the "rsResult.Open" line.
I have confirmed that the client is running MDAC 2.8. Any ideas what
might be going on here for ONE client when it runs fine for 5-6 other
clients?
Thanks for your help!!!
