Why Windows wouldn't let me rename a folder I wasn't using

Windows kept saying Access is denied when I renamed a project folder; here is why Windows locks files and folders in use and how to find the program holding them.