For many years I haveused the foxpro ODBC driver to acces information for my crystal reports.
The main reason was if I put the reports on another computer where the path to the .dbf`s was different , I simply ammended the ODBC once and every report then worked from that path
Now on Windows 7 I have to use OLE DB for Visual Foxpro, which connects fine, BUT always looks in the same place even though I change it in the Microsoft Data Link file?
Any other way of having a single path that changes multiple reports?
The main reason was if I put the reports on another computer where the path to the .dbf`s was different , I simply ammended the ODBC once and every report then worked from that path
Now on Windows 7 I have to use OLE DB for Visual Foxpro, which connects fine, BUT always looks in the same place even though I change it in the Microsoft Data Link file?
Any other way of having a single path that changes multiple reports?