Hi Howard, I've never worked with Access before, but I'm thinking that you can create a FoxPro DLL, and then call the DLL from within you Access
application to update the native FoxPro table, this should be faster than
using ODBC.
Good Luck.
>I need to connect an Access front end to a VFP free table of about 200k records. User needs to update the VFP data using the Access forms. I have made the ODBC connection, however any attempt to update a field is VERY slow. The ODBC connection is over a network but generally performance is not an issue.
>Question: are there any configuration or adjustment tweaks that will improve speed on this ODBC link?
>Thanks
>Howie Brown
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould