How to use OLE DB in Access 2007?

[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

 

[Douglas J. Steele]

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.

 

[Ankan]

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

 

[Douglas J. Steele]

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

 

[Ankan]

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 -

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

 

[Ankan]

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 -

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