Printable View
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?
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 :)
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