PHI Loader.accdb: Difference between revisions
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 6: | Line 6: | ||
If the msg is '''Run time error 58-File already exists''' then | If the msg is '''Run time error 58-File already exists''' then | ||
* 2 copies of CSV file, one OUTSIDE of the PHI_CSV_Archive, and the other copy is INSIDE the PHI_CSV_Archive. | * 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 | ||
* and log occurrence under [[#Task error message: Run time error 58-File already exists]] | * and log occurrence under [[#Task error message: Run time error 58-File already exists]] | ||
| Line 17: | Line 17: | ||
If the msg is '''Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"''' then | If the msg is '''Run time error 7874, "Microsoft Access can't find the object "AppendNewRecords"''' then | ||
* observation: this occurred at peak time an lots of staff sending. | * observation: this occurred at peak time an lots of staff sending. | ||
**Solution: Replaced PHI loader with backup copy. | **'''Solution''': Replaced PHI loader with backup copy. | ||
* and log occurrence under [[#Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords"]] | * and log occurrence under [[#Task error message: Run time error 7874 "Microsoft Access can't find the object "AppendNewRecords"]] | ||