ODBC and Excel
Posted by Roy Thompson on July 31, 2001 11:20 AM
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)
The error is raised on the first line.
Any suggestions gratefully received.