Prev: System Error &H80004015 (-2147467243) running VB6 IDE ActiveX DLL
Next: Hide Column in MSHFlexgrid
From: bfryman on 1 Feb 2006 09:52
I have a program developed in Visual Basic 6 that uses an Access
database. The program has almost 500 users now and someone called
today asking about a run-time error I have never seen before. It is:

"Run-Time Error 3706: Provider cannot be found. may not be properly
installed."

The error pops as soon as they double-click the program to start it.
The person is running Windows XP SP2. I had the person do the basic
things such as updating the Jet Engine to the latest version (4.0 SP8),
updating their MDAC to the latest (2.8), updating VB Runtime to 6.0
SP6, and updating Windows Script to 5.6. None of these things worked
and still got the same error message.

After doing some research on the error code it sounds like it has more
to do with MDAC then anything else. So I ran the MDAC Utility
Component Checker and a MDAC Repair Utility to make sure it's running
the correct version, even in the Registry and still no luck. This is
the only person with this problem - hundreds of other people have
Windows XP SP2 and use the program with no problem, including myself.
Any suggestions?

From: Paul Clement on 2 Feb 2006 11:08
On 1 Feb 2006 06:52:01 -0800, bfryman(a)gmail.com wrote:

? I have a program developed in Visual Basic 6 that uses an Access
? database. The program has almost 500 users now and someone called
? today asking about a run-time error I have never seen before. It is:
?
? "Run-Time Error 3706: Provider cannot be found. may not be properly
? installed."
?
? The error pops as soon as they double-click the program to start it.
? The person is running Windows XP SP2. I had the person do the basic
? things such as updating the Jet Engine to the latest version (4.0 SP8),
? updating their MDAC to the latest (2.8), updating VB Runtime to 6.0
? SP6, and updating Windows Script to 5.6. None of these things worked
? and still got the same error message.
?
? After doing some research on the error code it sounds like it has more
? to do with MDAC then anything else. So I ran the MDAC Utility
? Component Checker and a MDAC Repair Utility to make sure it's running
? the correct version, even in the Registry and still no luck. This is
? the only person with this problem - hundreds of other people have
? Windows XP SP2 and use the program with no problem, including myself.
? Any suggestions?

Sounds like they have a problem with their configuration/installation. You may want to have them try
the MDAC fix:

http://www.macropool.com/en/download/mdac_xp_sp2.html

If you're using the Jet OLEDB Provider you may want to have them try to register the file:

regsvr32 msjetoledb40.dll


Paul
~~~~
Microsoft MVP (Visual Basic)
From: bfryman on 2 Feb 2006 12:04
Paul,

you are the man - thank you for your help - I knew it had something to
do with MDAC, just wasn't aware it wasn't installing 2.81 - thanks
again!

Brad

 | 
Pages: 1
Prev: System Error &H80004015 (-2147467243) running VB6 IDE ActiveX DLL
Next: Hide Column in MSHFlexgrid