Compact-and-repair the data repository

From CCMDB Wiki
Revision as of 10:42, 2012 September 19 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

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_data.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 Copying down a clean version of CCMDB.mdb.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Compact-and-repair_the_data_repository&oldid=28392"