Troubleshooting: Difference between revisions

(37 intermediate revisions by 3 users not shown)

Line 1:

~~When opening Access [[CCMDB.mdb]], cannot view dropdown~~ list ~~in labs,~~ or ~~pharm or even the DX codes. Weird things in note section......to name a few things. Access has seized up on local laptop for reason unclear....~~.

This article is a list of troubleshooting actions data collectors can take if they run into problems with their laptop and/or data collection program.

*If ~~data files~~ are ~~not aligning with program files~~ for a ~~specific site~~, this is ~~what can be done~~ if ~~what is causing corruption cannot be identified:~~

== General problems ==

# If a program on your computer has crashed, see [[Breaking out of a frozen program]]

# If your problem is related to printing, keyboard/mouse not working, network or email access:

#* reboot the computer

#* if still a problem, contact the [[Helpdesk]]

# If you are '''missing shortcuts''' on your desktop, [[Desktop shortcuts for collection laptops|refresh your desktop shortcuts]]

# If the problem is an '''error or something weird on your screen''', '''[[Taking a Screenshot|take a screenshot]]''' of the problem. Finish troubleshooting and then email the [[Laptop identifier]] (e.g. H9, S4 or G7), the '''[[Pat ID]]''' where this happened, and the [[screen shot]] to [[tech support]]. Also mentioned whether you managed to fix the problem and if so, how.

# If something doesn't show up on your screen and you are connected to your second monitor, make sure that monitor is powered on; if still nothing shows, disconnect from the docking station and check if things show up then.

*Instruction: How to replace local laptop C:\ [[~~Ccmbd~~ program~~\ccmdb.mdb~~]]

== CCMDB problems ==

~~#Close out of Access program on laptop.~~

# If the problem is leaving you with a frozen program, then try [[Breaking out of a frozen program]] and restart [[CCMDB.accdb]] to see if it was only a glitch

~~#*Go to:~~[[~~Regional Server~~]]

# If there is a problem in [[CCMDB.accdb]] (e.g. with dropdowns or how the program ''works''), or if the program asks "[[Do you want to save changes...]]", close out of the program and restart it.

~~#*find: '''Program''' folder~~

# If there is still a problem, try '''[[Copying down a clean version of CCMDB.accdb]]'''.

~~#*then find: '''Master''' folder~~

# If there is still a problem, the master version of [[CCMDB.accdb]] might be corrupted and [[tech support]] may have to [[Reverting back to an older version of CCMDB.accdb|revert back to an older version of CCMDB.accdb]].

~~#*double click~~ to ~~enter into the Master folder and~~ see ~~ccmdb.mdb~~

# If there is a problem with patient data you have entered (e.g. diagnoses missing for patients, or the program produces an error as you scroll through the patient list), '''[[Compact-and-repair the data repository]]'''.

#*right click and select '''COPY''' ccmdb.mdb from this folder.

# If the problem is related to the data side of the local program (e.g. the error talks about a missing table or index or similar) then try [[CCMDB data.mdb restore from Regional Server]]. This would of course blow away any data you have entered since your last [[News and Backup]] so make sure you try the other steps above first.

~~#On the~~ [[~~Regional Server~~]] ~~go back to '''Program''' folder~~

~~#*find~~ the ~~specific~~ '''~~Hosp_Loc~~'~~'' PROGRAM folder that needs~~ the ~~update~~

~~#*double click~~ to ~~enter into~~ the ~~file folder~~

~~#*right click~~ and ~~select '''PASTE'''~~

~~#Go to the Desktop on laptop~~.

#*Click on '''[[~~News and Backup~~]]'''

#~~on local laptop~~, ~~go to C:\~~ [[~~Ccmdb_data\ccmdb~~.~~mdb~~]]

~~#*double click~~ to ~~open ccmdb~~.~~mdb with usual password~~. ~~IMPORTANT NOTE: will only see [[L_files~~]].

#*at the ~~very top of~~ the ~~Access program screen~~, ~~click on '''TOOLS''' menu.~~

~~#*select '''Database Utilities'''~~

~~#*select~~ '''Compact and ~~Repair Database~~'''

#*close out of ~~C:\~~ [[~~Ccmdb_data\ccmdb~~.mdb]] ~~by clicking the "X" in the top right corner~~.

~~#on local laptop, go to: C:\~~[[~~Ccmbd program\ccmdb.mdb~~]] ~~folder.~~

~~#*double click to log into ccmdb.mdb with usual password.~~

~~#*Problem should be resolved. The '''Access program''' file should now be realigned with '''Access data''' file~~.

@@ Line 1: / Line 1: @@
-When opening Access [[CCMDB.mdb]], cannot view dropdown list in labs, or pharm or even the DX codes.  Weird things in note section......to name a few things.  Access has seized up on local laptop for reason unclear.....
+This article is a list of troubleshooting actions data collectors can take if they run into problems with their laptop and/or data collection program.
-*If data files are not aligning with program files for a specific site, this is what can be done if what is causing corruption cannot be identified:
+== General problems ==
+# If a program on your computer has crashed, see [[Breaking out of a frozen program]]
+# If your problem is related to printing, keyboard/mouse not working, network or email access:
+#* reboot the computer
+#* if still a problem, contact the [[Helpdesk]]
+# If you are '''missing shortcuts''' on your desktop, [[Desktop shortcuts for collection laptops|refresh your desktop shortcuts]]
+# If the problem is an '''error or something weird on your screen''', '''[[Taking a Screenshot|take a screenshot]]''' of the problem. Finish troubleshooting and then email the [[Laptop identifier]] (e.g. H9, S4 or G7), the '''[[Pat ID]]''' where this happened, and the [[screen shot]] to [[tech support]]. Also mentioned whether you managed to fix the problem and if so, how.
+# If something doesn't show up on your screen and you are connected to your second monitor, make sure that monitor is powered on; if still nothing shows, disconnect from the docking station and check if things show up then.
-*Instruction: How to replace local laptop C:\ [[Ccmbd program\ccmdb.mdb]]
+== CCMDB problems ==
-#Close out of Access program on laptop.
+# If the problem is leaving you with a frozen program, then try [[Breaking out of a frozen program]] and restart [[CCMDB.accdb]] to see if it was only a glitch
-#*Go to:[[Regional Server]]
+# If there is a problem in [[CCMDB.accdb]] (e.g. with dropdowns or how the program ''works''), or if the program asks "[[Do you want to save changes...]]", close out of the program and restart it.
-#*find:  '''Program''' folder
+# If there is still a problem, try '''[[Copying down a clean version of CCMDB.accdb]]'''.
-#*then find: '''Master''' folder
+# If there is still a problem, the master version of [[CCMDB.accdb]] might be corrupted and [[tech support]] may have to [[Reverting back to an older version of CCMDB.accdb|revert back to an older version of CCMDB.accdb]].
-#*double click to enter into the Master folder and see ccmdb.mdb
+# If there is a problem with patient data you have entered (e.g. diagnoses missing for patients, or the program produces an error as you scroll through the patient list), '''[[Compact-and-repair the data repository]]'''.
-#*right click and select '''COPY''' ccmdb.mdb from this folder.
+# If the problem is related to the data side of the local program (e.g. the error talks about a missing table or index or similar) then try [[CCMDB data.mdb restore from Regional Server]]. This would of course blow away any data you have entered since your last [[News and Backup]]  so make sure you try the other steps above first.
-#On the [[Regional Server]] go back to '''Program''' folder
-#*find the specific '''Hosp_Loc''' PROGRAM folder that needs the update
-#*double click to enter into the file folder
-#*right click and select '''PASTE'''
-#Go to the Desktop on laptop.
-#*Click on '''[[News and Backup]]'''
-#on local laptop, go to C:\ [[Ccmdb_data\ccmdb.mdb]]
-#*double click to open ccmdb.mdb with usual password.  IMPORTANT NOTE: will only see [[L_files]].
-#*at the very top of the Access program screen, click on '''TOOLS''' menu.
-#*select '''Database Utilities'''
-#*select '''Compact and Repair Database'''
-#*close out of  C:\ [[Ccmdb_data\ccmdb.mdb]] by clicking the "X" in the top right corner.
-#on local laptop, go to:  C:\[[Ccmbd program\ccmdb.mdb]] folder.
-#*double click to log into ccmdb.mdb with usual password.
-#*Problem should be resolved.  The '''Access program''' file should now be realigned with '''Access data''' file.
+See also: [[Cognos downtime procedure]]
---[[User:TOstryzniuk|TOstryzniuk]] 17:08, 13 October 2010 (CDT)
+== If you can't fix it (downtime procedure) ==
+If you can fix you laptop problem through the steps about, no tech shows up, don't spend more than 30-40 mins on it.
+*Do not leave the work premise without manager permission
+# If there is another laptop because someone is not working that day, please work on that laptop
+# Use the time to review Wiki articles and catch up on latest. Answer questions or clean up article that needs clearer instructions. See [[Questions]] for a list of questions.
+== Related articles ==
+{{Related Articles}}
-[[Category: IT Instructions]]
+[[Category:IT Instructions]]
-[[Category: CCMDB.mdb]]
+[[Category:CCMDB.accdb]]