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