From: "Leyne, Sean" <sleyne@...>

> Artur & Woody,
>
> I have just done a search of the MSDN information...
>
> The only way to force Windows to flush it's buffers, is using the file
> handle for the file.
>
> Since the file handle is not available, there is no way of forcing the
> flush from outside the engine.

Try this link and look at the utility called Sync 2.0.

http://www.sysinternals.com/ntw2k/source/misc.shtml

I think you'll find it interesting. It let's you force NT to flush it's
buffers to disk. You could use this in a call from a UDF or just run it at
set times.

Woody