p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

activex_data_objects thread: Re: ActiveX Error Message

Message #1 by "Beata Chrulkiewicz" <moominek@h...> on Thu, 2 Aug 2001 21:16:14

Make sure your Dao360.dll is registered on the client machine. You may 

want to check out that article from Microsoft:



> Not sure if this is the right place to post this but here goes...I am 

> attempting to link from my Excel worksheet to an ODBC data source and 


> getting the message "Run Time Error 429. ActiveX Component can't create 

> object" when using DAO to make the link.


> I have got all the references to DAO set and the code runs fine on my 

> standalone PC. But when I install it on a client's machine it gives me 


> above error. Is it something to do with workgroup membership??


> The offending code is:


> Dim wrkODBC As Workspace

> Dim conBOM As Connection

> Dim strConnect As String


>     Set wrkODBC = CreateWorkspace("ODBCWorkspace", "Roy", "", dbUseODBC)

>     strConnect = "ODBC;DATABASE = SageLine132;UID = Roy;DSN=SageLine132"

>     Set conBOM = wrkODBC.OpenConnection("BOM", , , strConnect)        

>     etc, etc. 


> The error is raised on the first line.


> Any suggestions gratefully received.


> Roy Thompson


  Return to Index