Compact-and-repair the data repository: Difference between revisions
TOstryzniuk (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (10 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
Some problems with the [[CCMDB. | Some problems with the [[CCMDB.accdb]] 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 == | == How to do a '''Compact and Repair Database''' on ccmdb_data.mdb == | ||
''Note: These instructions '''do not refer to your regular | ''Note: These instructions '''do not refer to your regular [[CCMDB.accdb]]''' 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 | ||
# Double-click “my computer” on your desktop | # Double-click “my computer” on your desktop | ||
| 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. It will only get smaller if you have not very recently done run a compact. Compacting to smaller size only works once at a time. If it doesn't, then proceed with steps below. Note: you would have to be entering data again for a shift or two before you see your data get bloated in size once again. | |||
== If the automatic fix does not work == | == If the automatic fix does not work == | ||
| Line 19: | Line 21: | ||
If this still does not work, proceed with the steps in [[Troubleshooting]]. | If this still does not work, proceed with the steps in [[Troubleshooting]]. | ||
==Related info== | |||
As of [[CCMDB.mdb_Change_Log_2013#ver_2013-06-10]] Sub compact_runner() does the compact and repair on opening. | |||
Another option to run a compact and repair from the command line involves [[Compact repair data.vbs]]. | |||
[[Category: IT Instructions]] | [[Category: IT Instructions]] | ||
Latest revision as of 10:47, 2019 September 22
Some problems with the CCMDB.accdb 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.accdb 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. It will only get smaller if you have not very recently done run a compact. Compacting to smaller size only works once at a time. If it doesn't, then proceed with steps below. Note: you would have to be entering data again for a shift or two before you see your data get bloated in size once again.
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.
Related info
As of CCMDB.mdb_Change_Log_2013#ver_2013-06-10 Sub compact_runner() does the compact and repair on opening.
Another option to run a compact and repair from the command line involves Compact repair data.vbs.