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

Use copy_to_local.bat if your ccmdb.mdb program "isn't working right". A lot of problems will be fixed by getting a fresh version of the program. Often it will be the first thing Tina would get you to try anyway, so you can save yourself time by just trying this first.

To replace local laptop C:\CCMDB_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 using the copy_to_local.bat file
   1. double-click the Regional Server icon on your desktop
   2. double-click on Programs, then on Master
   3. double-click on copy_to_local or copy_to_local.bat (whichever is listed, depends on the setup of your PC)
   4. close out of the explorer window
3. Try your program. Hopefully it works now, if not try #Fixing a problem with the data repository.

Usually your program is kept up-to-date by the News and backup process, only use copy_to_local if something is going wrong.

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-tables
   • 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.