Run-time error '429' ActiveX component can't create object

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
 
Top