Well, after the following procedure, I have corrected the problem, along with speeding up the load/exit cycles, it now closes in 10 seconds (remotely):
- Started new empty FE database.
- Imported the (small) tables from the original.
- Linked to the BE tables manually.
- Forged each Query from scratch copying the SQL code from the original FE version.
- Created each Form & Report manually, setting each property for each form/report, then copied all textboxes/controls/buttons/labels from the original.
- Created & copied the vba into the modMouseHook module.
- Created & copied the vba into the custom functions module.
- Copied all the vba from all the forms and reports.
All seems to be well so far, and I have added "Option Explicit" to all modules. It took me about 10-12hrs. work, but I think it may be well worth it, as I have seen no hint of instability after compacting, so far. It used to take 90 seconds just to close (remotely), now just about 30, compact is faster too. Thank you all for your help.