429 crash

R

rich

Test machine is XP with all updates. Office XP (Access and
Word only) are installed with all service packs. Norton AV
is the only other software on the machine. This Access
program crashes with Error 429: "ActiveX component can't
create object" on the New SQLDMO.Application line.

Private Sub Form_Load()
Dim osqlserver As SQLDMO.Application
Dim namX As SQLDMO.NameList

Set osqlserver = New SQLDMO.Application
Set namX = osqlserver.ListAvailableSQLServers

Dim i As Integer
For i = 1 To namX.Count
MsgBox namX.Item(i)
Next i

End Sub

How can I fix this machine so I can test my software?
 
Top