I have an Excel macro that connects to a Foxpro table. It was working for long time. Recently when running the same Excel file on Windows 7 machine it fails with Excel VBA error Driver does not support this function (-2147467259) It is still working fine from XP computer using Excel 2003 or 2007
Setup on windows 7 64 bit OS
Outlook 2007 VBA macro: VBA Project References Microsoft ActiveX Data objects 2.7 Library (I tried 2.8 and 2.6 and the same results) The connection string: "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\serverpath\;Exclusive=No;"
It fails on connection object.open Any idea?
Thanks in advance Moshe
Setup on windows 7 64 bit OS
Outlook 2007 VBA macro: VBA Project References Microsoft ActiveX Data objects 2.7 Library (I tried 2.8 and 2.6 and the same results) The connection string: "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\serverpath\;Exclusive=No;"
It fails on connection object.open Any idea?
Thanks in advance Moshe