Dear James,

    'Hope this might fix your problem:
  
1.   Compare the dll's/ocx's in your test PC and development PC.  
     msadodc.ocx Microsoft ADO Data Control  (assuming that you're using the
ADO data control)
     msbind.dll  Microsoft Data Binding Collection Object DLL (assuming that
you are associating the ado to an object such as textbox)
     Note that if you look at the msbind.dep, msbind uses the following
dll's.
        Uses1=ComCat.dll
        Uses2=MSStdFmt.Dll
You also have to compare these dll's. 
    I can't tell you which versions to keep.  It all depends on what other
applications are being run on the test PC.
    If you are using VB5 you will get a huge headache with regards to these
dll's.

2.   Make sure the Access mdb file exists in the same directory as specified
in the program. 

      Good luck!
                                -Regina 
-----Original Message-----
From: texter@o... [mailto:texter@o...]
Sent: Wednesday, May 24, 2000 10:01 PM
To: professional vb
Subject: [pro_vb] 3706 ADO Cannot Find Specified Provider


I have a simple program that searches through an Access mdb, and also 
imports numbers into the mdb. However, whenever I install and run the 
program, I get error number 3706 "ADO Cannot Find Specified Provider" The
machines have Access installed. The funny thing is if I install it and run
it on a machine that has VB installed, it runs fine. Is there a dll I need
to include in the install routine? Any help would be greatly appreciated.

James