Error 429 on opening Outlook 2007 from Access 2003

[Toots]

The following code runs fine from my computer, which is running
Windows XP, Access 2003, Office 2007, . There is no reference set to
Outlook. Other references are set for VB for Application, Access
11.0 , DAO 3.6, OLE Automation, and VB for Applications Extensibility.

Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.Application")


When I try to run the same code on a computer running Windows 7,
Access 2003,Office 2007 I get error 429.

Thanks for your suggestions.

 

[Rick Brandt]

The following code runs fine from my computer, which is running
Windows XP, Access 2003, Office 2007, . There is no reference set to
Outlook. Other references are set for VB for Application, Access
11.0 , DAO 3.6, OLE Automation, and VB for Applications Extensibility.

Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.Application")


When I try to run the same code on a computer running Windows 7,
Access 2003,Office 2007 I get error 429.

Thanks for your suggestions.

Make sure Office 2007 has Service Pack 2 installed. Automating Outlook
has always failed for me without that.