Active x issue

[Jim Bunton]

Win xp, access 2000, outlook 2000 SR-1 (9.0.0.3821)

***code snippet ***

Dim MysObject as object
Set myObject = CreateObject("Outlook.Application")

***END code snippet ***

gives error:-
429: ActiveX component can't create object

?? what's wrong! ??
[never was too sure about the ins and outs of Active X !]

 

[F.H. Muffman]

Win xp, access 2000, outlook 2000 SR-1 (9.0.0.3821)

***code snippet ***

Dim MysObject as object
Set myObject = CreateObject("Outlook.Application")

***END code snippet ***

gives error:-
429: ActiveX component can't create object

a) I'm pretty sure you should dim myObject as Outlook.Application, not as
object.
b) I'd also look at http://support.microsoft.com/kb/q244264/.