CCMDB.accdb: Difference between revisions

Line 1:

The '''CCMDB.mdb''' is ~~an MS '''~~Access~~'''~~ database, with the name being the ~~acronynm~~ 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.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]].

== Updating of CCMDB.mdb ==

Rolling out new versions of ccmdb.mdb is done by Tina or Trish using [[:Category: Batch Files | a batch file]] called [[updt_all.bat]]~~. A ccmdb.mdb file that is currently open WILL NOT be overwritten~~. 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.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.

== Data in the CCMDB.mdb ==

There are actually ~~2 data~~ files on the laptops:

There are actually 3 files on the laptops:

* c:\ccmdb_data\ccmdb.mdb where the data is stored

* c:\ccmbd_program\ccmdb.mdb, the program and user interface, this is what gets replaced with a new version

* c:\ccmbd_program\[[settings.mdb]], which stores localized settings

~~== File Locations ==~~

@@ Line 1: / Line 1: @@
-The '''CCMDB.mdb''' is an MS '''Access''' database, with the name being the acronynm 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.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]].
 == Updating of CCMDB.mdb ==
-Rolling out new versions of ccmdb.mdb is done by Tina or Trish using [[:Category: Batch Files | a batch file]] called [[updt_all.bat]].  A ccmdb.mdb file that is currently open WILL NOT be overwritten. 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.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.
 == Data in the CCMDB.mdb ==
-There are actually 2 data files on the laptops:
+There are actually 3 files on the laptops:
 * c:\ccmdb_data\ccmdb.mdb where the data is stored
 * c:\ccmbd_program\ccmdb.mdb, the program and user interface, this is what gets replaced with a new version
+* c:\ccmbd_program\[[settings.mdb]], which stores localized settings
-== File Locations ==
+See also [[Laptop Setup]]
-=== PDA ===
-Each [[PDA]] has a combo of two [[:Category: Access databases | Access databases]] associated to it:
-::'''ccmdb.mdb''' file which is identical for all until synced into
-::[[settings.mdb]] which contains location specific information such as the path to the [[Regional Server]], and the hospital and ward names.
-Additionally, this program 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 the master file, and then rolled out by copying the master\[[updt_all.bat]] [[:Category: Batch Files | batch file]] to a local drive (batch code can’t cope with running from an unnamed drive) and running it.
-=== Laptop ===
-see [[Laptop Setup]]
 == Form Sizes ==
-The form sizes on the laptops are continuously being tweaked to accomodate, especially, any of the laptops we use.
+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.
@@ Line 27: / Line 19: @@
 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 CCMDB.mdb is using the same password everywhere. {{Question IT}} This is required at all PDA locations because synchinc depends on it. Once the PDAs are phased out we might be able to customize passwords.
+The CCMDB.mdb is using the same password everywhere. {{Question IT}} This is required at all PDA locations because syncing depends on it. Once the PDAs are phased out we might be able to customize passwords.
 == Related Topics ==