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