PHI Loader.accdb: Difference between revisions
| Line 20: | Line 20: | ||
=== Problem log === | === Problem log === | ||
* 2019-02-14 | * 2019-02-14 Task error message: Run time error 58 | ||
* 2019-01-30 Task error message: Run time error 58. | * 2019-01-30 Task error message: Run time error 58. | ||
**Finding: 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and the other copy is INSIDE the PHI_CSV_Archive. | **Finding: 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and the other copy is INSIDE the PHI_CSV_Archive. | ||
***Solution: relabeled the copy INSIDE the PHI_CSV_Archive and put extension _Twin on the end. Ran the phi loader task scheduler. Problem solved | ***Solution: relabeled the copy INSIDE the PHI_CSV_Archive and put extension _Twin on the end. Ran the phi loader task scheduler. Problem solved | ||
* 2019-01-15 | * 2019-01-15 Task error message: Run time error 3078 | ||
* 2019-01-10 | * 2019-01-10 Task error message: Run time error 3078 | ||
* 2018-12-20 | * 2018-12-20 Task error message: Run time error 3078 | ||
* 2018-11-16 Task error message: Run time error 3078, "Microsoft Access can't find the input table or query tmp. | * 2018-11-16 Task error message: Run time error 3078, "Microsoft Access can't find the input table or query tmp. | ||
**Solution: Replaced PHI loader with backup copy | **Solution: Replaced PHI loader with backup copy | ||
* 2018-11-15 | * 2018-11-15 Task error message: Run time error 7874 | ||
* 2018-10-31 | * 2018-10-31 Task error message: Run time error 7874 | ||
* 2018-10-23 | * 2018-10-23 Task error message: Run time error 7874 | ||
* 2018-08-23 Task error message: Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords" | * 2018-08-23 Task error message: Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords" | ||
** observation: this occurred at peak time an lots of staff sending. | ** observation: this occurred at peak time an lots of staff sending. | ||