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 |
|
Anyting else anyone else can think of to test? |
Steps for update
- In CCMDB.mdb
- update sending
- In CFE
- update connecting
- in push/pull/copy,
- update filename
- \\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
- MCHP process?
Related articles
| Related articles: |