Hi,
Disable disk write caching in control panel/system and uncheck the write cache enabled in policies section of the disk drive properties on all workstations.

Disable oplocking on all workstations.

Also disable autodisconnect on all workstations.

BTW XP is not a good OS for a server.

>I've written a back end process that runs on the server. On a 5 second interval, it will check a work log to identify jobs that needs to be done. Once jobs are found, it will take records reciding in one directory and generate records to be inserted in other directories.
>e.g When company A issues a purchase requistion to its HQ and the HQ approves the requisition, the approval process would generate:-
>a) A purchase order from A to HQ for items that HQ is buying on behalf of A,
>b) A purchase order from HQ to supplier
>c) A purchase order from A to supplier (for items A is to sourced directly)
>d) A confirmed sales order in HQ's books for A's orders.
>
>The database and table structures are exactly the same for both HQ and A but they reside in different directories in the server:
>eg c:\app\database\A
> c:\app\database\HQ
>
>The backend program is a standalone exe that contains an OLEpublic class.
>
>The pseudocode goes as follows:-
>Open company A database
>Open company A tables
>Write in records for the purchase orders (via a begin /end tran)
>Close company A tables
>close company A database
>loops back and continue with HQ
>
>The problem is that once the records are posted, I'm not able to see any records in either HQ or A until I've completely logged out of the application and restart. (The backend exe is not terminated though and continues in the back ground)
>Weirder still is that for PCs on the network, it took almost 15 minutes before they could see those records.
>The server was an XP pro while clients are either XP pro or Win2k Workstations.
>Hope someone could shed some light.
>Yau