Compact-and-repair the data repository: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Ttenbergen moved page Compact-and-repairing the data repository to Compact-and-repair the data repository without leaving a redirect |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 9: | Line 9: | ||
#* close out of C:\Ccmdb_data\ccmdb_data.mdb by clicking the "X" in the top right corner. | #* 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 [[ | 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 10:42, 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!
- Make sure you are closed out of Access program
- 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 Copying down a clean version of CCMDB.mdb.