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