Compact/repair a local file

Compacting a local file:

• Removes empty space that remains after you delete records or move records to another file. Deleting or moving records does not remove the empty space the records once occupied, and the file size continues to grow unless you compact it.
  
  Compact a local file:
  • After you delete records from a local file
  • After you move records to another local file

   Caution: You cannot compact a local file if it is in use by another staff person.

• Repairs a file when you receive erroneous messages that records in a local file are in use by another (unlocks stuck records).
• Repairs indexes.

To compact and repair a file:

1. Navigate to File > Local File Manager or press <Alt><F><F>.
2. Under Choose File Type, select the type of file you want to compact and/or repair.
   • Bibliographic
   • Authority
   • Bibliographic Constant Data
   • Authority Constant Data
3. Select the name of the local file you want to compact and/or repair.
4. Click Compact File. The client confirms that compact/repair was completed.
5. If you continue to get sharing violation messages and still cannot open records in the file, do the following:
   1. Close the client, and shut down and restart your workstation.
   2. In Windows Explorer, check for the presence of a file with the extension *.ldb in the same folder as the local file.
      Default: X:\Documents and Settings\[user name]\Application Data\OCLC\Connex\Db (where X = the letter of your hard drive)
   3. If present, delete the *.ldb file and reclick the Compact File button.

       Note: If multiple people use this local file, follow this procedure on all workstations that access the file.