Hello, having trouble distributing an app that uses ADO to access a database. The app loads find on the target PC, but when I try to connect to the database with my connection string PROVIDER=JET.OLE.40(something like that), it says "ODBC provder not found or invalid data source"..I know the data source is valid, it executes perfect on the developement machine, but somewhere in the install it's not transferring the capability to use the JET engine to access the db...I included msjet40 and msjetole dll files and registered them, as well as all the files that the vb package and deployment wizard recomended...I can't seem to find a download for just the jet 4.0 installation files, I found every service pack update on MS's website..but not the actual installation. can anyone help?

Download the lastest version of Microsoft Data Access Components (MDAC) and the Jet 4.0 Service Pack from the Microsoft download section. For the MDAC, select the "MDAC" and for Jet, select the "Jet database engine" from "Product/Technology" list. When you'll have install these update, it should correct your problem.

Stéphane

That pointed me in the right direction. I had been distributing the MDAC that was on the Visual studio Cd, problem was...I had applied service packs and updated my own MDAC, but not the one that was actaully being used in the program. ;]