PHI Loader.accdb: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "X:\" to "{{S:\MED\CCMED}}" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{S:\MED\ | {{S:\MED\MED_CCMED}}CCMDB\PHI\PHI Loader.accdb is an Access program that processes data in [[PHI.mdb]] as part of [[PHI copy automation]]. | ||
== Troubleshooting tree == | == Troubleshooting tree == | ||
| Line 26: | Line 26: | ||
If the msg: '''Microsoft Access can't find the input table or query tmp''' then: | If the msg: '''Microsoft Access can't find the input table or query tmp''' then: | ||
*'''Solution''': | *'''Solution''': | ||
** which table is missing? If it is one you would see in [[ | ** which table is missing? If it is one you would see in [[Centralized_data.accdb]] then check if that file is somehow not accessible; same for PHI | ||
** if another table whose name means nothing to you is missing, then it's probably a table in PHI loader that got corrupted; Solution: Replace PHI loader with backup copy | ** if another table whose name means nothing to you is missing, then it's probably a table in PHI loader that got corrupted; Solution: Replace PHI loader with backup copy | ||
* and log occurrence under [[#Task error message: Run time error 3078]] | * and log occurrence under [[#Task error message: Run time error 3078]] | ||
| Line 45: | Line 45: | ||
=== Restoring PHI_Loader from backup === | === Restoring PHI_Loader from backup === | ||
* Close error message, and Click '''End''' | * Close error message, and Click '''End''' | ||
* Navigate to {{S:\MED\ | * Navigate to {{S:\MED\MED_CCMED}}CCMDB\PHI\PHI Loader.accdb_'''Backup''' | ||
* Before you restore the backup | * Before you restore the backup | ||
**Try to log in to the PHI_Loader using the pw (located on a list in M shared drive). If this does not work then | **Try to log in to the PHI_Loader using the pw (located on a list in M shared drive). If this does not work then | ||
| Line 116: | Line 116: | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||
[[Category: PHI]] | [[Category:PHI]] | ||
[[Category: IT Instructions]] | [[Category:IT Instructions]] | ||