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

m Text replacement - "TISS28.mdb" to "TISS28.accdb"
No edit summary
 
(8 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 ==
=== 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 ===
=== 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 ===
=== Steps for update ===
Line 23: Line 18:
** update sending - changed Ttenbergen 16:59, 2019 September 18 (CDT)
** 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''';
** getting error that can't link to newer format, so '''will need to change CCMDB.mdb as well''';
** updated ccmdb.mdb to ccmdb.accdb
** updated [[CCMDB.accdb]] to [[CCMDB.accdb]]
** update [[Backup.bat]] - completed Ttenbergen 17:25, 2019 September 18 (CDT)
** 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 [[Copy to local.bat]] - completed Ttenbergen 17:28, 2019 September 18 (CDT)
Line 46: Line 41:


[[Category:IT Support]]
[[Category:IT Support]]
[[Category:Centralized_data.accdb]]