p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

activex_data_objects thread: ActiveX Error Message

Message #1 by "Roy Thompson" <Rothco@m...> on Sun, 29 Jul 2001 14:11:30
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 keep 

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 the 

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