Accessing "in Use" Files == ?

[nihil]

I think that you are missing the point here?

If we use a simple application such as notepad or wordpad and we both open the same record and make changes to it; the last person to save their record will overwrite what the other person did. Including any valid changes they might have made that were not repeated in the last record. Locking only takes place for the few milliseconds the update takes.

In a collaborative system (such as MS office), if you open the record with edit rights you lock the record against all other potential editors. They can still read and copy the master record, but they cannot edit it, or save an edited copy.

That way, subsequent edits will overwrite that which is actually changed and NOT revert any data, inadvertently or fraudulently.

The OP was never clear about his circumstances, but I can think of a lot of situations where allowing a programmatic copy of a record that has been locked for editing would be a very bad idea from a security and business viewpoint. Invoices addresses, ship to addresses, credit limits, to name but a few. He did say this:

Now how can I copy this file to another location programmatically. Normal methods will fail with the error "The process cannot access the file because it is being used by another process.".