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.
dsoderstromAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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, ...in 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...
;-)


JeffCoachman
0
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.
0
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:
http://msdn.microsoft.com/en-us/library/xe736fyk%28v=vs.90%29.aspx
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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.
0
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...


JeffCoachman
0
dsoderstromAuthor Commented:
Apparantly no one has a solution for this so will close it
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dsoderstromAuthor Commented:
no other solution provided
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.