Data Access Problem

[slinky2000]

I have recently developed a program that works with an access database. I am using VB6. When packing it all up with Installshield or the Package deployment program within VB6 it theoritically copies all the ocx files over with it. However when I install the program on my friends 98 machine, I get can't find msadodc.ocx message when running the program. I have even tried installing the Microsoft Data Access Components package from MSDN. After installing this I get a new message when running the program. The message is can't find provider. If I install VB6 onto the Windows 98 machine, everything works fine.

Please help me
Thanks in advance

[Ianpbaker]

Sorry if this is stupid question, but when you get to the refernce section of the the Package deployment program, have you made sure you have included all of the refernce dll's that you App uses. If not this can cause the problem you have got.

Hope this helps

Ian

[slinky2000]

Yes I have ticked all the dependency files but still no joy.

[Clunietp]

did you install DCOM 98? Are you connecting to an Access 97 database?

First, you need to install DCOM 98

Second, if you are connecting to an Access 97 database, you need to distribute MDAC 2.0. If you installed VB6 SP3, that updated your MDAC version to 2.1, which does not include the Access 97 driver.

[slinky2000]

Thank You. It works. Will it work in NT4 as well?