How to use OLE DB in Access 2007?

  • Thread starter Thread starter Ankan
  • Start date Start date
A

Ankan

Hi! I want to link to a Visual Foxpro (ver 9) - table from Access. It
is NOT possible with ODBC. I have to use OLE DB. I cant find OLE DB in
the menus. Please help! Thanks /Ankan
 
You cannot link tables (nor use pass-through queries) using Ole DB. It
simply isn't supported.

If you cannot find an ODBC driver, then your only option will be to use ADO
recordsets, where you can specify Ole DB connection strings.
 
Thanks.
It works to link from Excel to Foxpro, can I link from Acces to Excel
to Foxpro? :-)
/Anders
 
I don't know. Have you tried?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Thanks.
It works to link from Excel to Foxpro, can I link from Acces to Excel
to Foxpro? :-)
/Anders
 
I don't know. Have you tried?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)


Thanks.
It works to link from Excel to Foxpro, can I link from Acces to Excel
to Foxpro? :-)
/Anders





- Visa citerad text -
Click to expand...

Yes, it works. But that's a slow and dirty solution in this century.
Don´t You think? I found this "The new VFP ODBC Driver released as
part of the Advantage Database Server Version 9.0 (Beta) is fully
compatible with VFP 9.0 Data." so now I can see the files in the list
but i still can't link to them. Maybe a friend can help my with a
workaround in SQL. Hmm. Thanks anyway. Anders
 
Yes, it works. But that's a slow and dirty solution in this century.
Don´t You think? I found this "The new VFP ODBC Driver released as
part of the Advantage Database Server Version 9.0 (Beta) is fully
compatible with VFP 9.0 Data." so now I can see the files in the list
but i still can't link to them. Maybe a friend can help my with a
workaround in SQL. Hmm.  Thanks anyway. Anders- Dölj citerad text -

- Visa citerad text -
Click to expand...

I solved the problem by following this advice "The new VFP ODBC Driver
released as part of the Advantage Database Server Version 9.0 (Beta)
is fully compatible with VFP 9.0 Data." Case Closed :-) /anders
 
Back
Top