Hi I am using the following code to connect to FoxPro, the code is working fine on one machine but on another machine I am getting a message 'ActiveX component cant create object'
cn.Connect = "SourceType=DBF;" _
& "SourceDB=" & ThisWorkBook.Path & "\Data\;" _
& "Driver={Microsoft Visual FoxPro Driver}"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection "rdDriverNoPrompt"
Any Suggesttions how to solve this problem probably arising due to the Driver?
Start Free Trial