Compact-and-repair the data repository: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 11: | Line 11: | ||
# Close Microsoft Access (it is closing that triggers the actual fix) 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. | Now try your program from the usual desktop shortcut. | ||
To know if it worked, you will see the size of you ccmdb.data get smaller. If it doesn't, then proceed with steps below. | |||
== If the automatic fix does not work == | == If the automatic fix does not work == | ||
Revision as of 16:47, 2013 June 19
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!
- Make sure you are closed out of Access program
- Double-click “my computer” on your desktop
- In the right panel, double click:
- “Local Disk (C:)”
- “ccmdb_data”
- “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 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.
To know if it worked, you will see the size of you ccmdb.data get smaller. If it doesn't, then proceed with steps below.
If the automatic fix 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
If this still does not work, proceed with the steps in Troubleshooting.
Suggestion
- Since ccmdb program is linked to ccmdb data, when exiting/closing ccmdb program.md is it possible to automatically run the compact and repair database during this time?Trish Ostryzniuk 13:25, 2013 June 12 (EDT)
- automating this isn't as simple as you'd think. See Scheduling compact-repair for .mdbs for some info, but nothing detailed. I have tried in the past and ended up shelving it. I still hope to do it some day, but until now it has not been a priority. When things settle down a little I will try again. It is still in the queue. Ttenbergen 10:07, 2013 June 13 (EDT)
- hopefully a programmer could help so that no junk gets into the ccmdb data trunk and pollutes TMPV2.mdb. Pagasa will put on her garbage mitts and go into TMPV2 and clean out the chinese things that got in there.