Conversion of Centralized data.mdb to Centralized data.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "This page is about the update of Centralized data.mdb to the newer .accdb format. == Reasons to do this == * Most immediately: ** hoping that this might fix the System..."
 
No edit summary
 
(31 intermediate revisions by the same user not shown)
Line 1: Line 1:
This page is about the update of [[Centralized data.mdb]] to the newer .accdb format.  
This page is about the update of Centralized_data.mdb to the newer .accdb format.  


== Reasons to do this ==
== Reasons to do this ==
Line 9: Line 9:


== Plan ==
== Plan ==
- In CCMDB.mdb
=== Testing completed ===
o update sending
* I have converted both [[CCMDB.accdb]] and [[Centralized_data.accdb]] to .accdb and done some basic testing, including sending. It seems to work.
- In CFE
* Julie confirmed that SAS can read .accdbs and that she accesses this data through [[CFE]] anyways.
o update connecting
 
- in push/pull/copy,  
=== Steps for update ===
o update location
* 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,  
** [[Push up centralized data.vbs]] - complete Ttenbergen 17:43, 2019 September 18 (CDT)
** [[Pull down centralized data.vbs]] - complete Ttenbergen 17:43, 2019 September 18 (CDT)
** [[Copy here only centralized data.vbs]] - complete Ttenbergen 17:43, 2019 September 18 (CDT)
* \\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}}
 
[[Category:IT Support]]
[[Category:Centralized_data.accdb]]

Latest revision as of 14:02, 23 July 2025

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"