Linked servers on SQL Server 2008 R2 through linked tables in MS-Access?
1
vote
1
answer
310
views
We have a really old data source (file-based) in Visual FoxPro, that we currently use via linked table through an ODBC data source. Recently, we started having an issue because the latest update to our Anti-virus Suite is stopping it from connecting in this manner. There are other ODBC data sources which do not use the same driver which do not have this issue.
Also the Visual FoxPro driver ODBC driver is being shoehorned in using the registry because it's no longer supported by Windows 7.
Is adding my Visual FoxPro data source as a linked server in SQL server and then in the MS-Access database, relinking the effected tables to it a possible solution to this issue? Note: the MS-Access databases use VBA and queries to retrieve and manipulate the data.
Asked by leeand00
(1722 rep)
Oct 1, 2015, 03:22 PM
Last activity: Oct 1, 2015, 08:32 PM
Last activity: Oct 1, 2015, 08:32 PM