CCMDB data.mdb restore from Regional Server

From CCMDB Wiki
Revision as of 12:25, 2020 March 2 by Ttenbergen (talk | contribs) (moved content from Restoring ccmdb data.mdb to here since this is the better name)
Jump to navigation Jump to search


This page describes how to restore a backed up version of CCMDB data.mdb. Only do this when something goes wrong. (see #When or why would you do this?)

Backups

There are two kinds of backups.

  1. When CCMDB.accdb closes it runs a Compact-and-repair automatically; this generates a file "ccmdb_data_backup.mdb". Usually this one will not solve your problem if you have accidentally deleted data you want to restore, but it might be helpful if there is simply data corruption.
  2. The series of backups created on the Regional Server when you run News and Backup

How to restore CCMDB_data.mdb

  1. Make sure you are closed out of Access program
  2. Check if the local backup is OK
    1. Navigate to the c:\ccmdb_data directory, for example
      1. Click on 'windows key' + "E" key on your keyboard
      2. paste c:\ccmdb_data into the address bar and hit enter
      3. rename the file ccmdb_data.mdb to ccmdb_data_corrupted.mdb (or steps further down will give errors)
    2. double-click on "ccmdb_data_backup" (or "ccmdb_data_backup.mdb")
      • if this opens you may have a good version, need to confirm:
      1. double-click on table L_Log in the list one the left
      2. check if your newest entered record is in there
    3. rename "ccmdb_data_backup.mdb" to "ccmdb_data.mdb"
  3. if the local backup didn't work out, try the backup on the Regional Server
    1. double-click on the Regional Server shortcut on your desktop, then navigate Regional Server\data\<Laptop identifier of this laptop> (full address: \\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\data\<Laptop identifier of this laptop>)
    2. double-click on "ccmdb_data" / "ccmdb_data.mdb"
      1. follow steps 2-4-... above to check if file is valid; even if not all data is here, this may be the best you got; if this file is also corrupted, work your way through the numbered backup files from newest to oldest until you find a good copy
      2. copy the good file to your C:\CCMDB_data directory and make sure it's called CCMDB_data.mdb with no other numbers or words (if it's the un-numbered file you are copying you can just double-click data_to_local.bat and follow its instructions
  4. open CCMDB.accdb from your desktop shortcut as usual
  5. Email tech support that you did this, and whether it fixed your problem. These instructions allow you to fix problems quickly when they happen, but we want to know if there are patterns of problems so we can prevent them in the first place.

When or why would you do this?

If CCMDB.accdb is not working correctly the program or the data repository might have become corrupted. This is not a big deal: the program is just a copy if the master version, and the data is backed up by you frequently.

Primarily you would follow the instructions in this article because you were directed to by tech support or by another article.

A lot of problems will be fixed by getting a fresh version of the program. Often it will be the first thing Tina would get you to try anyway, so you can save yourself time by just trying this first. See also Troubleshooting

Usually your program is kept up-to-date by the News and backup process, so you don't need to do this on a regular basis.

Log

  • 2019-04-12 (Fri/Mon) -
  • 2019-04-17 (Wed) happened

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB_data.mdb_restore_from_Regional_Server&oldid=142316"