CCMDB.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
PTorres (talk | contribs)
 
(28 intermediate revisions by 5 users not shown)
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 ==
== 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 ==
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


== Data in the CCMDB.accdb ==
Data in CCMDB.accdb is stored in
* c:\ccmdb_data\CCMDB data.mdb
* see: [[CCMDB data.mdb]]
See also [[Laptop Setup]]
See also [[Laptop Setup]]


Line 16: Line 14:
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 ==
== 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 Ostryzniuk |Trish]] or any data collector. All data collectors need to be thoughtful as to who they give this password out to.
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.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.
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.
{{Discussion}}
*As of beginning of September 2010, all [[PDA]]'s have be phased out. Not sure what you mean bu customizing passwords.  This may be a problem for folks sent to other sites for coverage.--[[User:TOstryzniuk|TOstryzniuk]] 17:52, 16 September 2010 (CDT)


== Related Topics ==
== Related articles ==
* [[Sending Patients]]
{{Related Articles}}
* [[Master files for the data collection process]]


[[Category:IT Instructions]]
[[Category: IT Instructions]]
[[Category: Data Repository]]
[[Category: Data Repository]]
[[Category: Questions_IT]]
[[Category: CCMDB.accdb | *]]
[[Category: CCMDB.mdb | *]]
[[Category: Password]]

Latest revision as of 11:28, 2023 December 15

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.

Updating of CCMDB.accdb Program

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

Data in the CCMDB.accdb

Data in CCMDB.accdb is stored in

See also Laptop Setup

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 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: