|
|
| (96 intermediate revisions by 11 users not shown) |
| 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]] or [[MedTMS]]. | | 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 == |
| Additionall'''Bold text'''y, 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. |
|
| |
|
| == Change Log == | | == Data in the CCMDB.accdb == |
| Starting May 27, 2008 the change log will be stored in the. See [[CCMDB.mdb Change Log]].
| | Data in CCMDB.accdb is stored in |
| | * c:\ccmdb_data\CCMDB data.mdb |
| | * see: [[CCMDB data.mdb]] |
| | See also [[Laptop Setup]] |
|
| |
|
| For 2009 see[[CCMDB.mdb_Change_Log_2009 | Change_Log_'''2009''']] for the latest.
| | == 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. |
|
| |
|
| [[User:TOstryzniuk|TOstryzniuk]] 23:08, 29 December 2008 (CST)
| | == Password == |
| | Located: \\AD.WRHA.MB.CA\WRHA\HSC\SHARED\WRHA\WRHA_CCMED\Passwords_mainoffice\Passwords_MainOffice_use.xlsx |
|
| |
|
| =DISCUSSION=
| | 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. |
| *ACCESS “(CCMDB)”. This article is pretty sparse at the moment. I would like each data collectors to collaborate in the development of this article. There are a number of questions in there to get things started, sort of a template. Basically what is needed is the “steps” followed to go through ACCESS (CCMDB.mdb) before data files are SEND to the regional server? Some of you may have some “good tips” that others can learn from so please add them to this articles. Any little detail from each collector will help this article grow into a useful guide. Don’t worry about how you put the information in this article or spelling etc. It can be reorganized as we go.
| |
| --[[User:TOstryzniuk|TOstryzniuk]] 23:21, 13 March 2009 (CDT)
| |
|
| |
|
| | 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. |
|
| |
|
| =Additional Info Required for ACCESS= | | == Related articles == |
| *will break out as separate pages once information has been populated in here.
| | {{Related Articles}} |
|
| |
|
| | | [[Category: IT Instructions]] |
| ==starting Access==
| | [[Category: Data Repository]] |
| *Before I enter access I take time to check by ready to send files on my PDA check that all required feilds have been addressed, I make list of missed items like pathogens needed, enter items as needed; then copy Hadibase L_files directly from my PDA Handibase L_files for my site folder onto the Regional server ensuring you are logged on the twister prior to;, click on new program icon on PC; choose appropriate ward; enter database password; click "find orphans"; click "pre-send Tmp2 checker" if needed; click edit patient's; click "filter" icon top right of screen. Then you are ready to perform final checks prior to sending go through files and follow prompts as needed (highlighted in yellow if any missed items arise); when your have reached the end and have ensured you have correct number of files ready; click "door" on right top corner and you will be back to the page you entered; click send files,and follow the prompts. Ensure that you label the batch sent appropriately. --[[User:JHutton|JHutton]] 09:46, 16 March 2009 (CDT)
| | [[Category: CCMDB.accdb | *]] |
| | | [[Category: Password]] |
| ==filtering to complete only==
| |
| ?
| |
| | |
| ==Yellow fields and error messages==
| |
| ?
| |
| | |
| ==Checking your Data in Access==
| |
| ?
| |
| | |
| ==other thing to do when using ACCESS==
| |
| ?
| |
| | |
| ==deleting in ACCESS==
| |
| ?
| |
| | |
| ==the process of sending your data from access==
| |
| ?
| |
| | |
| ==Deleting data after sending from access==
| |
| ?
| |
| | |
| | |
| | |
| | |
| | |
| {{discussion}}
| |
| == Discussion ==
| |
| * data collectors must participate and fill this information in.[[User:TOstryzniuk|TOstryzniuk]] 22:31, 29 October 2008 (CDT)
| |
| | |
| **'''ATTENTION''' to all Data collectors: please contribute to the above information in regards to the steps using ACCESS. This forum is a collaborative and was requested by data collectors thus we require your participation on the WIKI here. We need to have documentation of what steps that collector follow.[[User:TOstryzniuk|TOstryzniuk]] 23:31, 26 February 2009 (CST)
| |
| **Confused, why gather this information when we are expecting lap-tops soon and the process will change?--[[User:JHutton|JHutton]] 09:53, 16 March 2009 (CDT)
| |
| ***Thank you for your contribution. All sites being able to use a lap-top is some time away. At this time we will only use laptops at one site for beta testing. Never-the-less, the lap top will employ the use of '''MS ACCESS''' for collection and entry, therefore the above steps are will still apply. --[[User:TOstryzniuk|TOstryzniuk]] 13:26, 16 March 2009 (CDT)
| |
| | |
| {{stub}}
| |
| [[Category:IT Instructions]]
| |
| [[Category:Question for Data Collectors]]
| |
| [[Category: Questions_IT]] | |
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