Tags: access, automation, database, installed, microsoft, mulitple, mysql, office, office2003, oracle, outlook, sql, unitl, versions

automation with outlook 2007

On Database » Microsoft Access

3,528 words with 2 Comments; publish: Sun, 01 Jun 2008 13:56:00 GMT; (25078.13, « »)

I have mulitple office versions installed (Access 97, 2000, 2003, Office

2003, Office 2007)

Unitl recently automation to Outlook 2007 from Access worked (in Access

2003)

However something (update, installation of visio, project 2003,...??)

created an issue.

Any of my code trying to create the outlook object gives the following kind

of error: "automation error, the specified module could not be found"

The reference is set to "C:\Program Files\Microsoft

Office\Office12\MSOUTL.OLB", this file is still there at the indicated place

by the reference.

Is there any way to register this file again (like with a a regsvr32.exe for

a dll file) (or to solve it otherwise).

Could I just copy the file from another machine and replace it?

I read somewhere that a reinstall of office might be necessary which could

be

a complete nightmare as i have all thise different versions. Could I just

install and reinstall Outllook?

Thx

Philip

All Comments

Leave a comment...

  • 2 Comments
    • I would try unchecking the reference and closing the References dialog. Then

      open the References dialog again, scroll down to Microsoft Outlook and

      re-check it. If you can see the reference in the dialog, it should be ok

      once you select it.

      "phleduc" <Ph.Leduc.ms-access.todaysummary.com.REMOVEcomcast.net> wrote in message

      news:Oc0JOdPtHHA.3504.ms-access.todaysummary.com.TK2MSFTNGP06.phx.gbl...

      >I have mulitple office versions installed (Access 97, 2000, 2003, Office

      > 2003, Office 2007)

      > Unitl recently automation to Outlook 2007 from Access worked (in Access

      > 2003)

      > However something (update, installation of visio, project 2003,...??)

      > created an issue.

      > Any of my code trying to create the outlook object gives the following

      > kind

      > of error: "automation error, the specified module could not be found"

      > The reference is set to "C:\Program Files\Microsoft

      > Office\Office12\MSOUTL.OLB", this file is still there at the indicated

      > place by the reference.

      > Is there any way to register this file again (like with a a regsvr32.exe

      > for a dll file) (or to solve it otherwise).

      > Could I just copy the file from another machine and replace it?

      > I read somewhere that a reinstall of office might be necessary which could

      > be

      > a complete nightmare as i have all thise different versions. Could I just

      > install and reinstall Outllook?

      #1; Sun, 01 Jun 2008 13:57:00 GMT
    • Hi Paul,

      tried to recheck references, did a compact /repair before rechecking, that

      did not work (also problem from different .mdb files) , also did try to copy

      the file from another computer, did not work either, did a repair on office

      2007, did not help either...

      just leaving to a three week trip abroad so don't want to mess too much,

      still would be happy to know if you see any other options (would

      uninstalling outlook and reinstalling work?)

      philip

      "Paul Shapiro" <paul.ms-access.todaysummary.com.hideme.broadwayData.com> wrote in message

      news:%23TeBHyPtHHA.1164.ms-access.todaysummary.com.TK2MSFTNGP02.phx.gbl...

      >I would try unchecking the reference and closing the References dialog.

      >Then open the References dialog again, scroll down to Microsoft Outlook and

      >re-check it. If you can see the reference in the dialog, it should be ok

      >once you select it.

      > "phleduc" <Ph.Leduc.ms-access.todaysummary.com.REMOVEcomcast.net> wrote in message

      > news:Oc0JOdPtHHA.3504.ms-access.todaysummary.com.TK2MSFTNGP06.phx.gbl...

      >

      #2; Sun, 01 Jun 2008 13:59:00 GMT