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

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
No edit summary
Line 1: Line 1:
To fix a problem with the CCMDB.mdb program, use Access' "Compact and Repair Database".  
Some problems with the [[CCMDB.mdb]] program can be fixed by doing a "Compact and Repair Database". This happens automatically when the data repository is opened and closed.
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!
 
== How to do a "Compact and Repair Database" on ccmdb_data.mdb ==
''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!
# Make sure you are closed out of Access program
# Make sure you are closed out of Access program
# Open C:\CCMDB_data\[[CCMDB_data.mdb|ccmdb_data.mdb]] with usual password
# Double-click “my computer” on your desktop
#* because this is the data repository, your main form will not show up and you will only see [[L-tables]]
# In the right panel, double click:
#* at the very top of the Access program screen, click on '''TOOLS''' menu
## “Local Disk (C:)”
#* select '''Database Utilities'''
## “ccmdb_data”
#* select '''Compact and Repair Database'''
## “ccmdb_data.mdm”; enter the usual password; because this is the data repository, your main form will not show up and you will only see [[L-tables]]
#* close out of C:\Ccmdb_data\ccmdb_data.mdb by clicking the "X" in the top right corner.
# Close Microsoft Access (it is closing that triggers the actual fix) by clicking the "X" in the top right corner.
Now try your program from the usual desktop shortcut.
 
== If the automatic change does not work ==
Try the above process again, but before closing do the following:
# at the very top of the Access program screen, click on '''TOOLS''' menu
# select '''Database Utilities'''
# select '''Compact and Repair Database'''
 


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]].


[[Category: IT Instructions]]
[[Category: IT Instructions]]

Revision as of 09:24, 2013 June 7

Some problems with the CCMDB.mdb program can be fixed by doing a "Compact and Repair Database". This happens automatically when the data repository is opened and closed.

How to do a "Compact and Repair Database" on ccmdb_data.mdb

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. Double-click “my computer” on your desktop
  3. In the right panel, double click:
    1. “Local Disk (C:)”
    2. “ccmdb_data”
    3. “ccmdb_data.mdm”; enter the usual password; because this is the data repository, your main form will not show up and you will only see L-tables
  4. Close Microsoft Access (it is closing that triggers the actual fix) by clicking the "X" in the top right corner.

Now try your program from the usual desktop shortcut.

If the automatic change does not work

Try the above process again, but before closing do the following:

  1. at the very top of the Access program screen, click on TOOLS menu
  2. select Database Utilities
  3. select Compact and Repair Database
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Compact-and-repair_the_data_repository&oldid=33710"