Linking a Visual Fox Pro file to Microsoft Access hangs

[dbguru316]

I have a visual fox pro database file where a few of the tables are linked to
a Microsoft Access application. I only use this link to retrieve data from
the vfp database, and never write to it.

The issues that I have discovered are two-fold:
1) Many times MS Access seems to "hang" and there is no recovery other than
to halt the task through the task manager, and
2) On some rare occasions I seem to break indexes on the vpc db that must be
fixed.

Is there a way to changes the Visual Fox Pro ODBC driver to be read-only?

Also, is seems to that append queries using the vfp as source are the worst.
Do you recommend any alternative approach?

Tim

[Anders Altberg]

The ODBC driver hasn't bee updated since VFP6. As of VFP7, VFP comes with an
OLE DB driver, VFPOLEDB.DLL that you can download from Microsoft if you
haven't got it already.
There've been numerous changes to the SQL implementation, data types and the
database, and the commands and functions supported in stored procedures, all
of which are unknown to he ODBC driver.

-Anders

Post by dbguru316
I have a visual fox pro database file where a few of the tables are linked to
a Microsoft Access application. I only use this link to retrieve data from
the vfp database, and never write to it.
1) Many times MS Access seems to "hang" and there is no recovery other than
to halt the task through the task manager, and
2) On some rare occasions I seem to break indexes on the vpc db that must be
fixed.
Is there a way to changes the Visual Fox Pro ODBC driver to be read-only?
Also, is seems to that append queries using the vfp as source are the worst.
Do you recommend any alternative approach?
Tim