D
Dave
Hi
I have an application running in Access 2003 that is trying to open a
second Access application
and get the following error
Run-time error '429' ActiveX component can't create object
The references all seem OK - I have references to
Visual Basic for Applications
MS Access 10.0 Object Library
MS DAO 3.6 Object Library
MS ACtiveX Data Objects 2.1 Library
OLE Automation
My code is as follows
Dim acApp As Access.Application
Dim strDBPath As String
strDBPath = "C:\NewAppName.mdb"
Set acApp = New Access.Application
With acApp
..OpenCurrentDatabase strDBPath
..DoCmd.OpenForm "frmStart", acNormal
End With
It compiles OK, but fails at the line Set acApp = New
Access.Application
Thanks
I have an application running in Access 2003 that is trying to open a
second Access application
and get the following error
Run-time error '429' ActiveX component can't create object
The references all seem OK - I have references to
Visual Basic for Applications
MS Access 10.0 Object Library
MS DAO 3.6 Object Library
MS ACtiveX Data Objects 2.1 Library
OLE Automation
My code is as follows
Dim acApp As Access.Application
Dim strDBPath As String
strDBPath = "C:\NewAppName.mdb"
Set acApp = New Access.Application
With acApp
..OpenCurrentDatabase strDBPath
..DoCmd.OpenForm "frmStart", acNormal
End With
It compiles OK, but fails at the line Set acApp = New
Access.Application
Thanks