Re: VBA Error #429: ActiveX component can't create object
- From: "Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx>
- Date: Thu, 06 Sep 2007 18:00:45 -0600
Manuel <Manuel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a VBA procedure which sends an email. This procedure was running
fine when I was on Windows Professional 2000. Last week I was upgrade to
Windows XP, and now when I run the code I get the following error message:
VBA Error #429: ActiveX component can't create object
The problem may not be in Outlook but in Access.
You might need to register the DAO dll using regsvr32. For example
regsvr32 "C:\Program Files\Common Files\Microsoft
Shared\DAO\DAO360.DLL". (If A97 then DAO350.DLL.)
ACC: Error Message: ActiveX Component Can't Create Object [Q296205]
ACC2000: Error Message: ActiveX Component Can't Create Object
ACC2002: Err Msg: "ActiveX Component Can't Create Object"
I?ve confirmed that I have the Microsoft Outlook 11.0 Object Library
Now are all your users running the same version of Office? If there
is a possibility they will be running different versions of Outlook
then I'd consider converting your code to use Late Binding.
Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.
You'll want to install the reference if you are programming or
debugging and want to use the object intellisense while in the VBA
editor. Then,. once your app is running smoothly, remove the
reference and setup the late binding statements.
For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
The above statements aren't actually doing much if anything at all in
your code. I'd let the error handler do it's thing. But if you do
want to leave them in I'd make very, very sure I put DoCmd.SetWarnings
True at the top of your error handling routine right below the
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/