CCMDB data.mdb restore from Regional Server

From CCMDB Wiki
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. Make a backup of the current ccmdb_data.mdb file
    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_pre_<the date>.mdb (e.g. ccmdb_data_pre_20200301.mdb)
  3. restore the backup from the Regional Server to the laptop
    1. double-click on the Regional Server shortcut on your desktop
    2. 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>)
    3. double-click data_to_local.bat and follow its instructions to copy the backup to your laptop
  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=142686"