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