Conversion of Centralized data.mdb to Centralized data.accdb

From CCMDB Wiki
Jump to navigation Jump to search

This page is about the update of Centralized_data.mdb to the newer .accdb format.

Reasons to do this

  • Most immediately:
  • More generally:
    • bringing format up-to-date
    • better encryption

Plan

Testing completed

  • I have converted both CCMDB.accdb and Centralized_data.accdb to .accdb and done some basic testing, including sending. It seems to work.
  • Julie confirmed that SAS can read .accdbs and that she accesses this data through CFE anyways.

Steps for update

  • Update to and encrypt centralized_data.accdb - update and encryption complete Ttenbergen 16:59, 2019 September 18 (CDT)
  • In CCMDB.mdb
    • update sending - changed Ttenbergen 16:59, 2019 September 18 (CDT)
    • getting error that can't link to newer format, so will need to change CCMDB.mdb as well;
    • updated CCMDB.accdb to CCMDB.accdb
    • update Backup.bat - completed Ttenbergen 17:25, 2019 September 18 (CDT)
    • update Copy to local.bat - completed Ttenbergen 17:28, 2019 September 18 (CDT)
    • update Updt all.bat - completed Ttenbergen 17:28, 2019 September 18 (CDT)
  • In Centralized data front end.accdb
    • update connecting - complete and rolled out Ttenbergen 17:35, 2019 September 18 (CDT)
  • \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\ push/pull/copy,
  • \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\PHI\PHI Loader.accdb
    • update var old_path - changed Ttenbergen 17:49, 2019 September 18 (CDT)
  • TISS28.accdb
    • update reconnect script - complete Ttenbergen 17:53, 2019 September 18 (CDT)
  • \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb
    • update var Centralized_data - completed Ttenbergen 20:26, 2019 September 18 (CDT)
  • \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\MCHP\Master\MCHP Export.accdb
    • update function centralized_data - completed Ttenbergen 20:30, 2019 September 18 (CDT)

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Conversion_of_Centralized_data.mdb_to_Centralized_data.accdb&oldid=165526"