Reconnect CFE and initial error checks

Once you "Pull" Centralized_data.accdb you need to initialise the program and make sure that you have consistent initial data.

Instructions

• click the "Re-connect Data" button
• the reconnector will do the following
  • no need to run them manually
  • confirm if L_Log table and L_PHI table have the same records in them. If they don't there will be an error; see Procedure when there are differences between L Log and L PHI for how to proceed
  • runs the initial cross checks, but only shows them if errors are found. If there are errors, correct them before proceeding to the next step,
    • Reconnect_check_Completes query - Generally, errors in missing are the result of a failed send, so follow Re-sending data to fix
    • Reconnect_check_orphans query - see Orphans in Centralized_data.accdbfor what to do about these
    • Reconnect_check_missing_L Tables_content query - Generally, errors in missing are the result of a failed send, so follow Re-sending data to fix

• If there were no errors, continue what you were doing, likely the next step of Centralized data Vetting Process: Pre-linking checks