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)
The error is raised on the first line.
Any suggestions gratefully received.