Troubleshooting

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

1. Make sure you are closed out of Access program
2. 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

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!

1. Make sure you are closed out of Access program
2. Open C:\ccmdb_data\ccmdb_data.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.