Conversion of Centralized data.mdb to Centralized data.accdb
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 resource exceeded error
- More generally:
- bringing format up-to-date
- better encryption
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.
Testing remaining
Could you test if your SAS program can access the .accdb version of this with minimal changes? A test version is in regional server\output\centralized_data.accdb |
Steps for update
- In CCMDB.mdb
- update sending
- In CFE
- update connecting
- \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\ push/pull/copy,
- update filename in script
- \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\PHI\PHI Loader.accdb
- update var old_path
- \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb
- update var Centralized_data
- \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB_Special_Projects\MCHP\Master\MCHP Export.accdb
- update function centralized_data
- TISS28.mdb
Related articles
Related articles: |