Connect to external table with OLE

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
.

Relevant Pages

  • Re: Update FoxPro 6 table from ado
    ... The OLE DB ... data provider is preferable since it works against all versions of FoxPro ... ODBC only works on tables in the VFP6 format and below. ... FoxPro SQL statements are not terminated with a semicolon. ...
    (microsoft.public.vb.database.ado)
  • Re: FoxPro ODBC DSN Problem
    ... FoxPro tables is the same as any other ODBC or OLE DB compliant database. ... Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ...
    (microsoft.public.data.odbc)
  • Re: import data from FoxPro database (ISIS)
    ... I have the ODBC driver on my computer. ... I'm a little confused about setting up the OLE DB stuff, ... you've got Visual FoxPro files. ... The DBC table is a "database container" ...
    (microsoft.public.access.externaldata)
  • Re: Installing foxpro oledb on SQL 2005 64 bit
    ... None of the ole providers on my 64 bit SQL 2005 seem to suggest that they are ... Is there a 64 bit OLE DB provider for ODBC? ... Over time new data features have been added to FoxPro tables. ...
    (microsoft.public.data.oledb)
  • Re: import data from FoxPro database (ISIS)
    ... you've got Visual FoxPro files. ... The DBC table is a "database container" ... that don't have the new features are still compatible with ODBC. ... A typical OLE DB connection string is ...
    (microsoft.public.access.externaldata)