Error 2147024770 sending mail via Outlook 2003 from Access 2003

[AndyKeen]

Hi,

Hope somebody can help. I have an Access based app which creates mails into outlook 2003 for editing etc by the user. Has been running perfectly for some months and is loaded on a number of machines. Recently one m/c has started generating an error when trying to create the outlook application object. The error is 2147024770(8007007e). I can't find any ref to this problem ref Access although there mentions in relation to Exchange. Have tried M/s suggested solutions. Have also tried re-installing Office, IE & outlook express. Have checked reg entries ref m/s not re error 428 automation error. Just can't solve the problem. Please help if you can - I am completely stuck!

Thanks

 

[mp9]

Two questions:

1. Does the user with the problem have a reference in their copy of the DB to the Microsoft Outlook Object Library? (in VBA window, Tools, References)

2. If you step through the code on the user's PC, at what line/command does it fall over?

http://www22.brinkster.com/accessory/

 

[AndyKeen]

HI There,

Thanks for replying.

There is a reference set up in the users copy of the Access code database which points to the Outlook library. I have checked this, removed it and reinstated it - seems fine.

The line it creates the error on is the first of the three below.

Set myOLApp = CreateObject("Outlook.Application")
Set myItem = myOLApp.CreateItem(olMailItem)
Set myAttachments = myItem.Attachments

As I said in my first mail this works on the other machines and actually worked happily on this PC until recently. The db has not been changed since it stopped so it looks like it must be something external?

Any help would be really appreciated.

Thanks again

 

[PHV]

What happens if the user launch outlook (not outlook express) from the desktop ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AndyKeen]

Hi PHV

Everything is fine with Outlook. The user has experienced no problems in normal use. I tried running the the db app with closed and with it already open. It is the same either way - I still get the error when trying to create the outlook object.

Thanks for your interest, hope you can help point me in the right direction.