Compact-and-repair the data repository: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Ttenbergen moved page Compact-and-repairing the data repository to Compact-and-repair the data repository without leaving a redirect
(No difference)

Revision as of 10:10, 2012 September 19

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.