Making MS ACCESS ActiveX Automation Calls from LABVIEW

[Dargm]

Hi

I am trying to create a LABVIEW application which interfaces to a MS ACCESS 2010 database application. My LABVIEW application needs to call a custom subroutine that passes arguments by reference in the ACCESS Application.

I am running into trouble making an ActiveX automation call to ACCESS which utilizes the MS ACCESS "Application" Object "RUN" method.

When I try to create a reference to the MS ACCESS "Application" Object, LABVIEW returns Error 3005, which states that the Object is non creatable.  I am able to do this same type of call to EXCEL, no problem. Also I can perform this same automation call in VB, but would prefer to utilize LABVIEW.

I see an example on the NI web site to call macros from ACCESS with using the "DoCmd" Object and the "RunMacro" Method, but this will not work in my application since I want to pass arguments to the ACCESS subroutine. 

Has anyone run into this issue ?

[PiDi]

Hi Dargm

Are you using "Access._Application" or "Access.Application" object? First one is indeed not createable (might be an interface, I think).

[Dargm]

Hi PiDi

That was the issue, I had mistakenly used Access._Application.

Thanks for pointing that out!

[BrianluoCN]

hi  PIdi,

i experienced same issue, how can i change to "Access.Application" object? Thanks