Troubleshooting: Difference between revisions

Revision as of 11:17, 14 October 2010

If CCMDB.mdb is not working correctly the program or the data repository might have become corrupted. This is not a big deal: the program is just a copy if the master version, and the data is backed up by you frequently.

It's not so easy to give examples of how you would know that something is corrupted, or whether it is the data or program side that is trouble. Generally:

if it is a problem with dropdowns or how the program works, then the fault is in the program
if the problem is with some of the data not being visible, or the program erroring as you scroll through the patient list, it's a problem with the data

If the program is messed up it was either corrupted or someone made inadvertent changes to it. If the data is corrupted, someone might have tried to enter something the program had absolutely no idea what to do with. The other option either way is that it was just one of those computer gremlins.

Fixing a problem with the program

To fix a problem with the CCMDB.mdb program, just download a fresh copy from the Regional Server.

To replace local laptop C:\ Ccmbd program\ccmdb.mdb

Make sure you are closed out of Access program
Get a new copy of the master version on the Regional Server
- Double-click the Regional Server folder on your desktop
- Go to Program\Master folder
- Double-click the copy_to_local.bat; close out of the explorer window
- Double-click on News and Backup

Try your program. Hopefully it works now, if not try #Fixing a problem with the data repository.

Fixing a problem with the data repository

To fix a problem with the CCMDB.mdb program, use Access' "Compact and Repair Database". Note: These instructions do not refer to your regular ccmdb.mdb that you can access from the desktop shortcut, you need to open the actual data repository which is stored elsewhere!

Make sure you are closed out of Access program
Open C:\ Ccmdb_data\ccmdb.mdb with usual password
- because this is the data repository, your main form will not show up and you 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.

Now try your program from the usual desktop shortcut. If the error still persists, and you have not tried yet, try #Fixing a problem with the program.

If neither of those fix the problem contact Tech Support.

@@ 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.....
+If [[CCMDB.mdb]] is not working correctly the program or the data repository might have become corrupted. This is not a big deal: the program is just a copy if the master version, and the data is backed up by you frequently.
-*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:
+It's not so easy to give examples of how you would know that something is corrupted, or whether it is the data or program side that is trouble. Generally:
+* if it is a problem with dropdowns or how the program ''works'', then the fault is in the program
+* if the problem is with some of the data not being visible, or the program erroring as you scroll through the patient list, it's a problem with the data
-*Instruction: How to replace local laptop C:\ [[Ccmbd program\ccmdb.mdb]]
+If the program is messed up it was either corrupted or someone made inadvertent changes to it. If the data is corrupted, someone might have tried to enter something the program had absolutely no idea what to do with. The other option either way is that it was just one of those computer gremlins.
-#Close out of Access program on laptop.
-#*Go to:[[Regional Server]]
-#*find:  '''Program''' folder
-#*then find: '''Master''' folder
-#*double click to enter into the Master folder and see ccmdb.mdb
-#*right click and select '''COPY''' ccmdb.mdb from this folder.
-#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.
+== Fixing a problem with the program ==
+To fix a problem with the CCMDB.mdb program, just download a fresh copy from the [[Regional Server]].
---[[User:TOstryzniuk|TOstryzniuk]] 17:08, 13 October 2010 (CDT)
+To replace local laptop C:\ [[Ccmbd program\ccmdb.mdb]]
+# Make sure you are closed out of Access program
+# Get a new copy of the master version on the Regional Server
+#* Double-click the [[Regional Server]] folder on your desktop
+#* Go to '''Program'''\'''Master''' folder
+#* Double-click the '''copy_to_local.bat'''; close out of the explorer window
+#* Double-click on '''[[News and Backup]]'''
+Try your program. Hopefully it works now, if not try [[#Fixing a problem with the data repository]].
+=== Fixing a problem with the data repository ===
+To fix a problem with the CCMDB.mdb program, use Access' "Compact and Repair Database".
+Note: These instructions '''do not refer to your regular ccmdb.mdb''' that you can access from the desktop shortcut, you need to open the actual data repository which is stored elsewhere!
+# Make sure you are closed out of Access program
+# Open C:\ [[Ccmdb_data\ccmdb.mdb]] with usual password
+#* because this is the data repository, your main form will not show up and you 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.
+Now try your program from the usual desktop shortcut. If the error still persists, and you have not tried yet, try [[#Fixing a problem with the program]].
+If neither of those fix the problem contact [[Tech Support]].
@@ Line 33: / Line 39: @@
 [[Category: IT Instructions]]
 [[Category: CCMDB.mdb]]
+[[Category: Bugs]]

Troubleshooting: Difference between revisions

Revision as of 11:17, 14 October 2010

Fixing a problem with the program

Fixing a problem with the data repository

Navigation menu

Search