John,

I just picked this message as a way to say...

Jim Livermore has reminded us all about a product called "Snap Server" that sure sounds like a probable solution for the 10 users max. Check it out at http://www.snapappliance.com/

It is very reasonably priced, as far as I'm concerned.

cheers

>Hi,
>I haved limited 3-4 workstation to access the "server" in my client site. And 1 workstation may/may not access the "server" to view current sales value time to time. Other than that, this pc will not access the database at "server".
>
>The result is, yes, it may cause illegal operation while access the index corrupted table.
>
>So, what do you think I should do in next step? use FLOCK/RLOCK instead of TRANSACTION?
>
>Pls advise
>
>Thank you