asked on

method '~' of object '~' failed

Hello,

I am getting exactly the same symptoms as described on this page
https://www.experts-exchange.com/questions/10217009/Runtime-Error-Method-'-'-of-object-'-'-failed.html
however the advice is a little out of date

The program I have written is in VB6 and connects to an A2k3 database. It works fine on the development system but on transferring it onto a client system which has office 2k7 installed I find the error message upon any attempt to connect to the db.

I presume there is some kind of DAO dll/ocx involved which is different between 2k3 and 2k7, can anyone advise?

Thanks

Rey Obrero (Capricorn1)

see this link for different connection config to A2007 db.

http://www.connectionstrings.com/access-2007

Scott McDaniel (EE MVE )

How does your VB6 program connect to the database? If you're using ADO, then cap's advice should work. If not, you'll need to let us know how the connection is being made.

ASKER CERTIFIED SOLUTION

kbirecki

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Chris Raisin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kbirecki

I run multiple instances of vb6 simultaneously all the time without problems.

daz84

ASKER

Thank you all very much for your responses. I ended up working around the problem by convincing the client to remove 2007 and install 2010.

I will try my best to get some office time to test the above solutions in order to properly close the question so it may be of more use to others

Darren