CCMDB data.mdb restore from Regional Server: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (moved content from Restoring ccmdb data.mdb to here since this is the better name)
 
Line 10: Line 10:
== How to restore CCMDB_data.mdb ==
== How to restore CCMDB_data.mdb ==
# Make sure you are closed out of Access program
# Make sure you are closed out of Access program
# Check if the local backup is OK
# Make a backup of the current ccmdb_data.mdb file
## Navigate to the <code>c:\ccmdb_data</code> directory, for example
## Navigate to the <code>c:\ccmdb_data</code> directory, for example
### Click on '''{{Windows key}} + "E"''' key on your keyboard
### Click on '''{{Windows key}} + "E"''' key on your keyboard
### paste <code>c:\ccmdb_data</code> into the address bar and hit enter
### paste <code>c:\ccmdb_data</code> into the address bar and hit enter
### '''rename the file ccmdb_data.mdb to ccmdb_data_corrupted.mdb''' (or steps further down will give errors)
### rename the file ccmdb_data.mdb to ccmdb_data_pre_<the date>.mdb (e.g. ccmdb_data_pre_20200301.mdb)
## double-click on '''"ccmdb_data_backup"''' (or '''"ccmdb_data_backup''.mdb''"''')
# restore the backup from the [[Regional Server]] to the laptop
##* if this opens you may have a good version, need to confirm:
## double-click on the [[Regional Server]] shortcut on your desktop
### double-click on '''table L_Log''' in the list one the left
## navigate {{Regionalserver|data\''<[[Laptop identifier]] of this laptop>''}}
### check if your newest entered record is in there
## double-click [[data_to_local.bat]] and follow its instructions to copy the backup to your laptop
## rename '''"ccmdb_data_backup.mdb"''' to '''"ccmdb_data.mdb"'''
# if the local backup didn't work out, try the backup on the [[Regional Server]]
## double-click on the [[Regional Server]] shortcut on your desktop, then navigate {{Regionalserver|data\''<[[Laptop identifier]] of this laptop>''}}
## double-click on "ccmdb_data" / "ccmdb_data.mdb"
### 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
### 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
# open [[CCMDB.accdb]] from your desktop shortcut as usual
# open [[CCMDB.accdb]] from your desktop shortcut as usual
# '''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.
# '''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.

Latest revision as of 18:43, 2020 March 18


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"