CCMDB.accdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 28: | Line 28: | ||
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 accomodate, 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. | The form size was increased to accommodate the screens on the laptops which are small but have a high native resolution. | ||
== CCMDB.mdb password == | == CCMDB.mdb password == | ||
| Line 38: | Line 34: | ||
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 synchinc depends on it. Once the PDAs are phased out we might be able to customize passwords. | ||
== | == Related Topics == | ||
* [[Sending Patients]] | |||
* [[Master files for the data collection process]] | |||
[[Category:IT Instructions]] | [[Category:IT Instructions]] | ||
Revision as of 14:22, 2010 August 18
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.
Updating of CCMDB.mdb
Rolling out new versions of ccmdb.mdb is done by Tina or Trish using 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 Changes for changes planned for the future.
Data in the CCMDB.mdb
Any data in the ccmdb.mdb is considered transient, the file can be replaced with an empty new version at any time On the laptops, the data listed by CCMDB.mdb is actually stored in c:\ccmdb_data\ccmdb.mdb, so the front end ccmdb can still be replaced at any time
Data in
The PDAs sync into CCMDB.mdb. At locations that use laptops only, data is entered manually.
Data out
in a format that can be imported into TMSX or MedTMS.
File Locations
PDA
Each PDA has a combo of two 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 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 size was increased to accommodate the screens on the laptops which are small but have a high native resolution.
CCMDB.mdb password
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 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. Template: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.