Run-time error 429

[bezaman]

I'm trying to open a database using this code:

[Highlight=VB]
Dim cnxn As New ADODB.Connection
Dim z As String

cnxn.Provider = "Microsoft.Jet.OLEDB.4.0"
z = CurrentDb.Name
cnxn.Open z
[\vbcode]

This works fine on my computer but when I try it on another computer I get this error message:

"ActiveX component can't create object"

Does anybody now how to fix this?

[lintz]

You need to install Microsoft ActiveX Data Objects on the other machine. To find out which you have selected click Project --> References.

Create a setup for your app then run it on the other machine so all the necessary files are installed.

HTH

[RobDog888]

There is also a Component Checker Tool from M$ that will scan
your system an inform you of the exact version, if any, you have.
This is the most accurate method to determine the version of MDAC.

MDAC Utility: Component Checker Home Page/Download