ADO problem

[Samie]

I've created a vb application that accesses an Access 97 database. The program works fine on most PC's in my office. We are on a Windows 2000 server. The problem is that there are three or four PC's out of 60+ that just won't run the program. They keep getting an error message "ADO could not find the specified provider". I just need some hints on where to look. Like I said, I've installed the setup.exe on all pc's, but these few just won't run the program.

Sam

[nullus]

according to MSDN, that error is generated when the OLE DB provider isn't installed properly on the pc. so you either have to reinstall MDAC or type this in the DOS prompt:

REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"

hope that helps

[Gerardus]

If you are using Jet 3.51 you will need to install Mdac_typ.exe 2.0 or 2.1 on each machine.