switching from odbc to oledb

[steve...@gmail.com]

Hi - I have an access 2007 database that I've linked via ODBC to a
foxpro v6 database. The database has recently been updraded to visual
foxpro v9. Now the odbc drivers don't work anymore. Microsoft says we
need to use the ole db provider to connect to the v9 foxpro database.
Do you need to write vb code to do this? Can't find any way to do this
from within the access application. Please help.

[Mary Chipman [MSFT]]

Did you see the following KB article which describes the problem and
the solution?

http://support.microsoft.com/kb/824264/

--Mary

[steve...@gmail.com]

On Apr 27, 11:26 am, "Mary Chipman [MSFT]"

Thanks Mary. The problem is that the odbc drivers no longer work with
v9 foxpro databases. We need to make this happen via OLEDB.

[Mary Chipman [MSFT]]

The Access linked table feature uses ODBC, so if there isn't an ODBC
driver for VFP9, then I assume you need to write VBA code that uses
ADO to access the data. But then again, I know absolutely nothing
about VFP, so this is just a guess. I'd start wtih the VFP home page
at http://msdn.microsoft.com/en-us/vfoxpro/default.aspx and see what
resources you can turn up. I can't believe other people haven't run
into the same issue, and tackling it from that end might be more
productive than a general purpose oledb newsgroup. Best of luck,

--Mary