According to MSDB article VFP ODBC driver cashes data for 5 seconds only. Your problem sounds more like an OS caching. What kind of network are you running? Did you check caching setting on the server and workstations?
>Here is the problem we have observed.
>An ODBC connection to a VFP DBC makes a change to that DBC
>Immediately after that, another ODBC connection to that same database is unable to see those changes.
>
>This is happening between different systems on the Web using VFP backends with the Microsoft VFP ODBC Driver version 6.x
>
>I know there is an article in the MSDN somewhat describing this problem. However, establishing a connection, killing that connection, and then re-establishing the connection, does not help.
>
>Typically, after some time, say 20 minutes, the data appears.
>
>Really would LOVE to resolve this, as it is KILLING us.
>
>Thanks in advance.
>
>Dave
--sb--