error 430 ado/mdac

[john morris]

I have an application that has 2 forms with text boxes/combo boxes and command buttons.
I have packaged the app up including mdac.exe and ado 2.5 library, when I install it on numerous lap tops and some desktop pc's it works fine but on some machines when I click a command button that reads an access database I get an error 430 'Class does not support Automation or does not support expected interface'.

I dont understand why it works on some machines but not on others, any information as to a solution for this would be very much appreciated as it was due to be up & running by now and because of this I cant distribute it.

Thanks in anticipation

[TheBao]

This is a conflict version in ADO. When doing package and deployment wizard, VB may pick up the wrong ADO version (not 2.5 as you reference in your project). To correct the problem, you need to install mdac_typ.exe version 2.5 manually on all machines.

Regards,
TheBao

[john morris]

If I install mdac version 2.5 manually onto each machine will it effect how the machine runs for any other programs that they use. It is a clients network and I'm not sure what else they work on.

Thanks

[TheBao]

When doing the package and deployment wizard, a file call mdac_typ.exe is stored in Support folder (if you have a reference to ADO).

This file is not of version 2.5 as you specify in your project. So replace this file with the file of version 2.5. When you run set up again, this file will be installed automatically.

Regards,
TheBao