CCMDB.accdb: Difference between revisions

(11 intermediate revisions by 3 users not shown)

Line 1:

The '''CCMDB.~~mdb~~''' is a Microsoft Access database, with the name being the acronym for '''Critical Care Medicine Database'''. CCMDB.~~mdb~~ screens the data for internal consistency and ranges, and then exports it for further processing during [[Sending Patients | sending]].

The '''CCMDB.accdb''' is a Microsoft Access database, with the name being the acronym for '''Critical Care Medicine Database'''. CCMDB.accdb screens the data for internal consistency and ranges, and then exports it for further processing during [[Sending Patients | sending]].

== Updating of CCMDB.~~mdb~~ Program ==

== Updating of CCMDB.accdb Program ==

Rolling out new versions of ~~ccmdb~~.~~mdb~~ is done by Tina or ~~Trish~~ using [[:Category: Batch Files | a batch file]] called [[updt_all.bat]]. See the update [[Log]] for information about changes, and see [[Requested CCMDB changes for the next version | Requested Changes]] for changes planned for the future.

Rolling out new versions of [[CCMDB.accdb]] is done by Tina or Lisa using [[:Category: Batch Files | a batch file]] called [[updt_all.bat]]. See the update [[Log]] for information about changes, and see [[Requested CCMDB changes for the next version | Requested Changes]] for changes planned for the future.

== Data in the CCMDB.~~mdb~~ ==

== Data in the CCMDB.accdb ==

Data in CCMDB.~~mdb~~ is stored in

Data in CCMDB.accdb is stored in

* c:\ccmdb_data\CCMDB data.mdb~~</file>~~

* c:\ccmdb_data\CCMDB data.mdb

* see: [[CCMDB data.mdb]]

@@ Line 1: / Line 1: @@
-The '''CCMDB.mdb''' is a Microsoft Access database, with the name being the acronym for '''Critical Care Medicine Database'''. CCMDB.mdb screens the data for internal consistency and ranges, and then exports it for further processing during [[Sending Patients | sending]].
+The '''CCMDB.accdb''' is a Microsoft Access database, with the name being the acronym for '''Critical Care Medicine Database'''. CCMDB.accdb screens the data for internal consistency and ranges, and then exports it for further processing during [[Sending Patients | sending]].
-== Updating of CCMDB.mdb Program ==
+== Updating of CCMDB.accdb Program ==
-Rolling out new versions of ccmdb.mdb is done by Tina or Trish using [[:Category: Batch Files | a batch file]] called [[updt_all.bat]]. See the update [[Log]] for information about changes, and see [[Requested CCMDB changes for the next version | Requested Changes]] for changes planned for the future.
+Rolling out new versions of [[CCMDB.accdb]] is done by Tina or Lisa using [[:Category: Batch Files | a batch file]] called [[updt_all.bat]]. See the update [[Log]] for information about changes, and see [[Requested CCMDB changes for the next version | Requested Changes]] for changes planned for the future.
-== Data in the CCMDB.mdb ==
+== Data in the CCMDB.accdb ==
-Data in CCMDB.mdb is stored in
+Data in CCMDB.accdb is stored in
-* c:\ccmdb_data\CCMDB data.mdb</file>
+* c:\ccmdb_data\CCMDB data.mdb
 * see: [[CCMDB data.mdb]]
 See also [[Laptop Setup]]
@@ Line 15: / Line 15: @@
 == Password ==
-Located: M:\Passwords_MainOffice_use</file>
+Located: \\AD.WRHA.MB.CA\WRHA\HSC\SHARED\WRHA\WRHA_CCMED\Passwords_mainoffice\Passwords_MainOffice_use.xlsx
-The password for the ccmdb.mdb is known as "the tasty password". If you don't know it, and need to know it, talk to [[Trish Ostryzniuk |Trish]] or any data collector. All data collectors need to be thoughtful as to who they give this password out to.
+The password for the [[CCMDB.accdb]] is known as "the tasty password". If you don't know it, and need to know it, talk to [[p:Trish Ostryzniuk |Trish]] or any data collector. All data collectors need to be thoughtful as to who they give this password out to.
-The CCMDB.mdb is using the same password everywhere. This used to be required to make sure the PDAs work. It is now required because collectors cover at different locations and using different passwords would get people to write them down. Since laptops are pointsec encrypted as well this should not be a problem.
+The [[CCMDB.accdb]] is using the same password everywhere. This used to be required to make sure the PDAs work. It is now required because collectors cover at different locations and using different passwords would get people to write them down. Since laptops are encrypted, and accessed using the user's network password, this should not be a problem.
+== Related articles ==
+{{Related Articles}}
+[[Category:IT Instructions]]
-[[Category: IT Instructions]]
+[[Category:Data Repository]]
-[[Category: Data Repository]]
+[[Category:CCMDB.accdb | *]]
-[[Category: CCMDB.mdb | *]]
+[[Category:Password]]
-[[Category: Password]]