How to Resolve the Error: The data file was not successfully repaired and optimized. Details: There is a file sharing violation. A different process might be using the file.

This error appears when you try to optimize the data file while the program is open. To resolve the error and optimize the data file, follow these steps:
  1. Close OnTime Management Suite and OnTime Dispatch.
  2. Restart either application, but do not log in.
  3. From the login window, click the Options… link located in the lower-left corner.
  4. Click the link labeled Optimize Data File option.