Run-time error 3706

1 Feb 2006 2:52 PM

bfryman

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?

1 Feb 2006 4:28 PM

Veign

What does your application do when it starts. Trace it down to a line of
code or section of code then post something back here. There is lots of
information on the error if you search Google but your guess is as good as
ours without seeing any code.

Also, don't multipost your question

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
Veign's Blog
http://www.veign.com/blog
--

<bfry***@gmail.com> wrote in message

Show quoteHide quote

news:1138805521.584122.69320@f14g2000cwb.googlegroups.com...
>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?
>

2 Feb 2006 4:08 PM

Paul Clement

On 1 Feb 2006 06:52:01 -0800, bfry***@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)

2 Feb 2006 5:04 PM

bfryman

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