Problem with OLE Automation in Access 2010

I am in the process of converting some Access 2003 databases to Access 2010.  One of these databases uses OLE Automation to call another application from vba code.  This done using the following line:
         Set OLEObj = CreateObject("Autovue.application")

  This line fails after converting the database to Access 2010 with the following error message:
         ActiveX component can't create object.

  I have "OLE Automation" in my list of references.
  Any ideas on what the problem may be.
Who is Participating?
dsoderstromConnect With a Mentor Author Commented:
Apparantly no one has a solution for this so will close it
Jeffrey CoachmanMIS LiasonCommented:
What are these "calls" doing?
And how were you using them..., and for what purpose?

The only use for OLE that I had what inserting documents into the database...

In other words, Access 2010, there might be a better or different way to do this...

In case I am not understanding something, lets see what other experts post...

dsoderstromAuthor Commented:
It is starting up an application called AutoVue which is an application for viewing CAD Drawings in several different formats.  Autovue has a built in scripting language and once I open it I can send parameters and commands from within vba code to open drawings, display them on the screen or send to a printer.
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Jeffrey CoachmanMIS LiasonCommented:
So why the need to do this from Access?

Have you considered just using "Shell"

Dim varApp as variant
varApp =Shell("C:\YouFolder\YourApp.exe",vbNormalFocus)

See here for more info:
dsoderstromAuthor Commented:
We're kind of getting off on a tangeant here but.....

The access application gathers up a bunch of item numbers required for a production run and stores them in a table.  It then reads through the table and finds the location of the drawing for each item and sends this information to AutoVue which opens the drawing and prints it. These drawings can be in any one of six different file formats.  I don't know of any application other than AutoVue that can interpret all of these different formats and print them.  

Doing if from access saves the user from having to manually search for each drawing, open it and print it.
Jeffrey CoachmanMIS LiasonCommented:
Oh, Ok...
Thanks for the explanation...

Perhaps your best bet would be to contact the makers of AutoVue and ask for advice...

Other than that, lets wait for other experts to chime in...

dsoderstromAuthor Commented:
no other solution provided
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.