Solved

VBA: Set oDom = CreateObject("msxml2.domdocument.4.0") = 429 ActiveX component can't create object

Posted on 2006-06-29
10
3,758 Views
Last Modified: 2012-06-27
Hello guys (and girls)

VBA (Access 2003) - XP clients

I've written an app that using the line ...

Set oDom = CreateObject("msxml2.domdocument.4.0")

... and it works fine on 99% of my clients.

I have one XP client that fails on this line with ...

429 ActiveX component can't create object

... i'm utterly baffled as to why this machine should fail. It's XP - it's been kicking around a little longer than the others, but has Office 2003 installed.

Got any idea where I should be looking ? ... like I said, works fine on about 50 machines, this 1 machine fails ... i've checked 'References' and can't see anything missing ... I thought it was a standard reference.

Don't know what else to update ...

... I might try a resinstall of Office, I guess *hmmmm*

S.S.



0
Comment
Question by:SpencerSteel
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 11

Assisted Solution

by:leclairm
leclairm earned 100 total points
ID: 17010666
Does this computer have the msxml2.dll installed??
0
 

Author Comment

by:SpencerSteel
ID: 17010679
good question - i'll check ... why would the other XP machines and not this one ?

Was it a SP thing ? - I'll go and check now ... *runs downstairs*

S.S.
0
 

Author Comment

by:SpencerSteel
ID: 17010808
.... yes - it was there. I tried updating it with a version from a working client. No difference. I notice there was msxml3 and 4 there as well.

The user is leaving shortly, so I might try some Windows Updates, Office updates and a resinstall  or something.

There's always one ...

S.S.
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 200 total points
ID: 17010977
You actually need to look for msxml4.dll, not msxml2.dll.

Time to run downstairs again ;o)
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 200 total points
ID: 17011802
Can you set a reference to msxml 4 on that machine just to test it is correctly registered?
0
 

Author Comment

by:SpencerSteel
ID: 17017044
Hello guys,

Right, there wasn't any MSXML4.dll files on that client, so I copied all of the MSXML4 files to the machine - and it still didn't work ...

Howwver - RORYA - excuse my ignorance, but how do I test if it is correctly registered .... remember, i'm just a lowly VBA developer !

And if I don't get back to you guys, it's because i'm on holiday all next week ... I will be back to solve this (at the moment, i've swopped out his machine)

Thanks so much,

S.S.
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 200 total points
ID: 17017077
Hi,
If the dll was not there and you have just copied it across to the machine, it cannot be registered. Open a command prompt window (Start-Run type cmd and press enter), change to the directory you copied the dll to - if it was C:\Windows\System32 and the prompt does not already say C:\Windows\System32>, then you would type:
c: and Enter
cd \windows\system32 and enter
then type
regsvr32 msxml4.dll
and you should get a message telling you if the registration succeeded.

HTH

Rory
0
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 200 total points
ID: 17017083
You need to copy two files for XML4. They are: msxml4.dll and msxml4r.dll

And you need to register msxml4.dll, which you can do by going to Start > Run and typing "regsvr32 msxml4.dll"
0
 

Author Comment

by:SpencerSteel
ID: 17017890
You all are wonderful !

I wonder why those DLL's were missing ? ... actually .... no ... wait ...

hang on a minute ....

... yes. I do believe, all of a sudden I couldn't care less anymore.

I am so fickle.

Have some points !

S.S.

0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 17018059
SS,
Ta for the points. Since you asked:
The DLL is a menial creature with all the enthusiasm of a sloth. As such, they never do anything off their own bat; rather they require to be called, and often poked with a WM_STICK message, in order to get them to do anything at all. Eventually, however, this sort of abuse takes its toll on the poor creatures and they have been known to slope off somewhere in search of a quiet life. They do seem to breed like rabbits though, so it's generally easy enough to find another one.
That's what I used to tell my users when they asked, anyway...
Regards,
Rory

PS I am, of course, lying - no user has asked me anything about a DLL. Ever.
PPS Yes, I have way too much free time today.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question