FLUSH works only on the local PC, not on the server which is why it isn't always effective, However, you said this only happens on Windows 10, so it should help. Reading the docs. it seems as FORCE does not apply, but I don't know specifics of your application.
>Hi Craig,
>
>Thanks. Somehow I thought (from a LONG time ago) that FLUSH was not effective - or maybe that was the problem with not seeing someone else's data on the network right away. I will give FLUSH a try. Any experience with the FORCE phrase of that command - necessary? Reading the help file, does not seem to be applicable.
>
>Albert
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer