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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top