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