CCMDB.accdb: Difference between revisions

Line 1:

The '''CCMDB.mdb''' stands for '''Critical Care Medicine Database'''. This is an '''Access''' database that the [[PDA]]s synchronize into. It screens the data for internal consistency and ranges, and then exports it in a format that can be imported into [[TMSX]] or [[MedTMS]].

Each [[PDA]] has a combo of two [[:Category: Access databases | 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.

Each [[PDA]] has a combo of two [[:Category: Access databases | Access databases]] associated to it:

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.

*'''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.

*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 [[:Category: batch files | a batch file]]. A ccmdb.mdb file that is currently open WILL NOT be overwritten.

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

*Trish or Tina roll out changes using this updt_all.bat

== Change Log ==

@@ Line 1: / Line 1: @@
 The '''CCMDB.mdb''' stands for '''Critical Care Medicine Database'''.  This is an '''Access''' database that the [[PDA]]s synchronize into. It screens the data for internal consistency and ranges, and then exports it in a format that can be imported into [[TMSX]] or [[MedTMS]].
-Each [[PDA]] has a combo of two [[:Category: Access databases | 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.
+Each [[PDA]] has a combo of two [[:Category: Access databases | Access databases]] associated to it:
-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.
+*'''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.
+*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 [[:Category: batch files | a batch file]].  A ccmdb.mdb file that is currently open WILL NOT be overwritten.
+*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.
+*Trish or Tina roll out changes using this updt_all.bat
 == Change Log ==