Finding out who/what is locking a file

This is an oldie but a goodie- Process Explorer from Sysinternals.
This application displays the running processes and the files they are using.