-
Title
"The process cannot access the file...because it is being used by another process" synchronizing -
Description
When trying to synchronize tables, after running the table compare, I get the following error message.
Exception: System.IO.IOException
Message : The process cannot access the file 'C:\Documents and Settings\TPDZAJA.NJDOT\Local Settings\Application Data\Quest Software\Toad for Data Analysts Trial 2.1\Plugins\Data Compare\2009_5_21_14_25_4\script.sql' because it is being used by another process. -
Cause
Something is using the file that Toad is trying to access and has it locked.
-
Resolution
WORKAROUND #1:
Close and re-open Toad. Run the compare and sync again.
WORKAROUD #2:
1) Close Toad.
2) Delete the 2009_5_21_14_25_4 folder located in the 'C:\Documents and Settings\TPDZAJA.NJDOT\Local Settings\Application Data\Quest Software\Toad for Data Analysts Trial 2.1\Plugins\Data Compare' directory.
3) Try doing the compare again.