Run-time error: '-2147467259(80004005)'

[PowerfulStar]

I am trying to open two Access databases and am able to connnect to one ok and retrieve some records, but when I try to retrieve a record from the second database with some criteria from the first db, I always get the above error with "Mothod 'Execute' of objection '_Connection' failed."

I am using VB 6 (working model edition) and the command is the <connection>.Execute(strSQL) where <connetion> is the string to connect to the database and strSQL has a valid and working SQL code (in Access).

Please help ... it's driving me nuts, as I am trying to learn VB.

Regards and thanks.


PowerfulStar

 

[CCLINT]

You'll need to show some code...


[/b][/i][/u]*******************************************************[sub]
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!