>>If this is critical data and you do not have a lot of coding invested, you might consider SQL Server or other data store that is far more robust (on reasonable hardware).
>
>My application is currently running at 200 client locations and ensuring hardware/ power failure is not 100% possible.
>
>Will SQL Server database not get corrupted in case of hardware/ power failure?
Specify that all PCs have a UPS. And if your customers don't use UPS, you charge them for the repair of their tables. The first repair is 100$, no. 2 is 200$, no. 3 is 400$, no. 4 is 800$, no. 5 is 1600$ and so on. They will very soon get the message, or you will get rich. Amd by the way, I am serious.