I'm using ADO 2.0 to connect to an access database. The point is I
created the database in Access 2000 and connected to the databse using
Microsoft Jet OLEDB 4.0 Provider. But then I came to know that the
Client had only Access 97 so I converted my Database using the
Database utility in Access 2000 to convert to Prior version of Access
and changed the provider to Microsoft Jet OLEDB 3.51.Now when I
try to create the installation program using Package & Deployment
Wizard it shows me that there are no dependencies for MSADO20.tlb.
If I still continue the setup program and try to install it on a
machine having Access 97 it gives me an error saying
"Specified Provider not found". The error number is 3706. This
happens even when I install MDAC_TYPE.exe before installing my Package
onto the client machine. Anyone knowing the answer please help me out.