Help with Access 2002

[cindyray]

I am trying to access a report in Access 2002 and I get an activex error. The error is: Runtime error 429. ActiveX can't create object.

I'm using this to begin the call to the report:

Dim MSAccess As Access.Application
Set MSAccess = New Access.Application

I have the Microsoft Access 10.0 Object Library referenced.
The report worked with Access 2000.
The debugger highlights the second line and MSAccess is nothing when I run the mouse over it.

Any ideas on what to do.

 

[Philly44]

Check your references. Your probably referneces DAO 3.0, if you are change it to 3.6 and it should work

 

[cindyray]

I'm using ADO 2.5