"Re-connect Data" button

Button on main page of CFE that disconnects and re-connects data sources used regularly by CFE.

The button needs to be clicked after each Pull because tables that are connected on one user's desktop would not be properly connected on another user's desktop.

The button also runs some basic consistency checks between data sources that are stored separately and can therefore not use relational integrity. See Procedure when there are differences between L Log and L PHI.

The program then also checks that the following queries are empty, and gives an error and a list if they are not:

• Reconnect_check_Completes query is opened to help the Data Processor initiate the Re-sending data process
• Reconnect_check_orphans query - Orphans in Centralized data.mdb for what to do about these
• Reconnect_check_missing_L_Tables_content query