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

← Older edit

@@ 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 ==
@@ Line 9: / Line 9: @@
 == Plan ==
-=== Uncertainties ===
-This file is used in automation and linked data a lot of places. I anticipate that we will not find at least some of them until after the change. I also anticipate that the erros will be fail-safe and noisy, and then easy to fix.
 === Testing completed ===
-I have converted both ccmdb.mdb and Centralized data.mdb to .accdb and done some basic testing, including sending. It seems to work.
+* 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.
-=== Testing remaining ===
-Julie confirmed that SAS can read .accdbs and that she accesses this data through [[CFE]] anyways.
 === Steps for update ===
@@ Line 23: / Line 18: @@
 ** 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.mdb to ccmdb.accdb {{DT | must change wiki references to this}}
+** 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)
@@ Line 35: / Line 30: @@
 * \\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'''''
+** 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'''''
+** update function ''centralized_data'' - completed Ttenbergen 20:30, 2019 September 18 (CDT)
-* '''[[TISS28.mdb]]
-** '''what?'''
 == Related articles ==
@@ Line 46: / Line 41: @@
 [[Category:IT Support]]
+[[Category:Centralized_data.accdb]]