>What would be the best approach to verify for exclusivity of a file? I need to make sure a file is available before attempting a move.
I think in the final analysis you have to just try to move it, wrapped in a TRY...CATCH.
You might be thinking:
1. Check if anyone else is using the file
2. If not, move it
But, someone else could start using the file between 1 and 2. Yes, the time span between 1 and 2 may be small, and the chance of that happening low, but it could happen.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up