Compact-and-repair the data repository

From CCMDB Wiki
Revision as of 10:09, 2012 September 19 by Ttenbergen (talk | contribs) (Created page with "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 acc...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 #Fixing a problem with the program.

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