Connect to external table with OLE

[Bernie Hunt]

Can Access connect to an external table with an OLE connection vs the
typical ODBC connect?

My application is attaching FoxPro tables in Access to link them with
native Access tables. The problem is that MS has not updated the ODBC
driver for FoxPro to work with V9 of VFP. When I try to connect with ODBC,
the tables are seen but can't connect. I verified programmatically that it
was an ODBC problem. The OLE driver for FoxPro works fine.

Can I use OLE to attach a table in Access?

Thanks,
Bernie

 

[Douglas J. Steele]

I haven't been able to find any way to make Ole DB work for attaching tables
(nor for pass-through queries)