CCMDB.accdb: Difference between revisions

(129 intermediate revisions by 12 users not shown)

Line 1:

The '''CCMDB.~~mdb~~''' is the ~~Access program~~ the ~~PDAs sync into~~. It screens the data for internal consistency and ranges, and then exports it ~~in a format that can be imported into TMSX~~.

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]].

~~Each PDA has a combo~~ of ~~two Access databases associated to it: a ccmdb~~.~~mdb file which is identical for all until synced into, and a~~ [[~~settings~~.~~mdb~~]] which contains location specific information such as the path to the regional server, and the hospital and ward names. Any data in the ccmdb.mdb is considered transient, the file can be replaced with an empty new version at any time. Rolling out new versions is done by batch ~~and a~~ file ~~that is currently open will not be overwritten~~.

== Updating of CCMDB.accdb Program ==

~~Additionally~~, ~~this programs folder contains a \Master directory where~~ the ~~master~~ version ~~of the ccmdb.mdb is stored. Any~~ changes ~~required to the program can be made on this master file, and then rolled out by copying~~ the ~~master\updt_all.bat batch file to a local drive (batch code can’t cope with running from an unnamed drive) and running it~~.

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.

==~~Additional Info Required~~==

== Data in the CCMDB.accdb ==

~~some of these as separate pages~~

Data in CCMDB.accdb is stored in

*''''' Checking your Data in ~~Access~~

* c:\ccmdb_data\CCMDB data.mdb

*~~''''' starting Access~~

* see: [[CCMDB data.mdb]]

*''''' filtering to complete only

@@ Line 1: / Line 1: @@
-The '''CCMDB.mdb''' is the Access program the PDAs sync into. It screens the data for internal consistency and ranges, and then exports it in a format that can be imported into TMSX.
+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]].
-Each PDA has a combo of two Access databases associated to it: a ccmdb.mdb file which is identical for all until synced into, and a [[settings.mdb]] which contains location specific information such as the path to the regional server, and the hospital and ward names. Any data in the ccmdb.mdb is considered transient, the file can be replaced with an empty new version at any time. Rolling out new versions is done by batch and a file that is currently open will not be overwritten.
+== Updating of CCMDB.accdb Program ==
-Additionally, this programs folder contains a \Master directory where the master version of the ccmdb.mdb is stored. Any changes required to the program can be made on this master file, and then rolled out by copying the master\updt_all.bat batch file to a local drive (batch code can’t cope with running from an unnamed drive) and running it.
+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.
-==Additional Info Required==
+== Data in the CCMDB.accdb ==
-some of these as separate pages
+Data in CCMDB.accdb is stored in
-*''''' Checking your Data in Access
+* c:\ccmdb_data\CCMDB data.mdb
-*''''' starting Access
+* see: [[CCMDB data.mdb]]
-*''''' filtering to complete only
+See also [[Laptop Setup]]
-*''''' Yellow fields and error messages
-*''''' Sending your data
-*''''' Deleting data once you have the OK, ...
+== Form Sizes ==
+The form sizes on the laptops are continuously being tweaked to accommodate, especially, any of the laptops we use.
+The form size was increased to accommodate the screens on the laptops which are small but have a high native resolution.
+== Password ==
+Located: \\AD.WRHA.MB.CA\WRHA\HSC\SHARED\WRHA\WRHA_CCMED\Passwords_mainoffice\Passwords_MainOffice_use.xlsx
+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.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}}
-{{stub}}
 [[Category:IT Instructions]]
+[[Category:Data Repository]]
+[[Category:CCMDB.accdb | *]]
+[[Category:Password]]