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

(7 intermediate revisions by 2 users not shown)

Line 1:

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.

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~~.~~mdb~~''' that you can access from the desktop shortcut, you need to open the actual '''data''' repository which is stored elsewhere!

''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

Line 11:

# 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 ==

Line 20:

Line 22:

If this still does not work, proceed with the steps in [[Troubleshooting]].

==~~Suggestion~~==

==Related info==

~~{{Discussion}}~~

As of [[CCMDB.mdb_Change_Log_2013#ver_2013-06-10]] Sub compact_runner() does the compact and repair on opening.

*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?[[~~User:TOstryzniuk|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 ~~pollute TMV2.mdb. Pagasa will put~~ on ~~her garbage mitts and go into TMPV2 and clean out the chinese things that got in there~~.

Another option to run a compact and repair from the command line involves [[Compact repair data.vbs]].

[[Category: IT Instructions]]

[[Category:IT Instructions]]

@@ Line 1: / Line 1: @@
-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.
+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.mdb''' that you can access from the desktop shortcut, you need to open the actual '''data''' repository which is stored elsewhere!
+''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
@@ Line 11: / Line 11: @@
 # 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 ==
@@ Line 20: / Line 22: @@
 If this still does not work, proceed with the steps in [[Troubleshooting]].
-==Suggestion==
+==Related info==
-{{Discussion}}
+As of [[CCMDB.mdb_Change_Log_2013#ver_2013-06-10]] Sub compact_runner() does the compact and repair on opening.
-*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?[[User:TOstryzniuk|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  pollute TMV2.mdb.  Pagasa will put on her garbage mitts and go into TMPV2 and clean out the chinese things that got in there.
+Another option to run a compact and repair from the command line involves [[Compact repair data.vbs]].
-[[Category: IT Instructions]]
+[[Category:IT Instructions]]