Access 2000 and later use ODBC to talk to Foxpro.
http://support.microsoft.com/?scid=kb;en-us;824264&spid=2509&sid=50
Older versions of Access (97 and back) were able to talk directly to Foxpro
using the ISAM driver.
I think this was the fastest method. Not sure why they changed it.
OLE DB is used in ADO and ADO.Net.
Bottom line - use ODBC.
--
Joe Fallon
"JudyG." <JudyG.[ at ]discussions.microsoft.com> wrote in message
news:1C1F7D41-58F4-447A-98CF-14AAA49ED648[ at ]microsoft.com...
[Quoted Text] > Can someone give me the differences and/or reasons of using the ODBC vs
> OLE
> DB connection between Access 2003 and Visual FoxPro database? I'm using
> ODBC
> right now, but the speed is terrible. Someone asked about OLE DB. I'm
> just
> starting the research but am not quite sure of the differences. Thanks in
> advance...
|