CCMDB.accdb
The CCMDB.mdb stands for Critical Care Medicine Database. This is an Access database that the PDAs 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 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.
- 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 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.
- 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.
Changes in the new version of CCMDB.mdb
We are getting ready to have everyone use the new version of the CCMDB that will work for the laptops. On the front, the changes are relatively minor. Some of the ones that have caused confusion are explained below. If you find any problems with this version, please see and participate in CCMDB Testing.
Form Sizes
The forms are all larger now. This might mean they don't fit onto your screen. If that is the case, change your screen resolution.
The form size was increased to accommodate the screens on the laptops which are small but have a high native resolution.
X out of Program
- We find that if you are in the program and you have enlarged the view box, and then you "X" out, it closes out the program, not just take you back to the start up page of "edit patients" etc. But if you are in the view box and you are in smaller screen and "X" out, it doesn't close the program it goes to the start up screen "edit patients". Which is what we want.Are we doing something wrong? gogogirl 14:33, 3 June 2009 (CDT)
- There should be two Xs at the top right corner. The top one closes the entire application, the bottom one only that screen. If you use the door button instead in the patient view form then there should be no confusion. I don't think this has changed between the regular app and this one, has it? Ttenbergen 13:25, 9 June 2009 (CDT)
Yellows that don't go away when the value is fixed
Sometimes the fields for values that appear to be correct are still highlighted in yellow.
If this happens, try putting a checkmark into the complete box corresponding to that tab. This will re-run the checks.
Also, if the error box at the bottom seems to have out-of-date info in it, click the "Reset Err" button.
This problem happens because some changes in data will affect multiple boxes (e.g. survive and discharge-to) and running all checks after every change would slow down the program further.
Lab, Pharm checks
If the settings are set to "ICU" then Lab and Pharm used to have a checkbox in the ccmdb.mdb that had to be checked if there were no labs or pharmacy. This was changed so that Lab and Pharm that are legitimately empty need to have "no drugs" or "no labs" entered (much like "no comorbids") before they can be checked off.
If the settings are set to "medicine" you will not need to check off the "lab" or "pharm" checkboxes in order to set the "final check" box to send the patient.
TISS box gone
There is no longer a TISS box at the top of the patient viewer. People told me there were not using it and that it was just extra work.
Object With Variable Error
Occasionally the following error comes up
Microsoft Office Access Object variable of With block variable not set - Patient <number> OK
This error occurs when the program has previously run into a different problem and is still "confused". If this happens, go back to the Main Form (i.e. exit out of the patient viewer) and click the "reset" button.
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. This is required at all PDA locations because synchinc depends on it. Once the PDAs are phased out we can customize passwords.
Before Synching
Some of you seem to do extensive checks before synching and letting CCMDB.mdb do checks for you. I am curious - why? I thought we made the ccmdb to automate and facilitate these checks. Any thoughts? Ttenbergen 22:25, 4 May 2009 (CDT) Template:Discussion
Synching
See Syncing the PDA
Sending Patients
See Sending Patients
Master File
see Master files for the data collection process
Deleting data on PDA after sending from access
What is the process everyone should follow before deleting sent patients from the PDA? Some people check with Pagasa, some check on the regional server that data has actually been posted. Is it a common occurrence for data not to have been posted? Ttenbergen 22:32, 4 May 2009 (CDT) Template:Discussion
- go to regional server Output folder.
Check Vic folder go to recent batch #.CSV check files, scroll to ensure all files present. say no to save if you change anything. Delete completed profiles off PDA. gogogirl 16:19, 18 March 2009 (CDT)
- After closing access I click on output, then your unit open up the info and check. eg the number of completes, admits, comorbs, etc. I then delete my completes on my PDA--PStein 08:36, 18 March 2009 (CDT)
- After sending you check your output by opening twister and clicking on output, then find your site and click on the batch number csv you just sent. Your sent files should appear, scroll across and make sure the areas that have to have information in them ie. admit date and time etc. are filled in. If everything looks OK close out and you can deiete your completed files. Lois -- LBilesky 14:47, 17 March 2009 (CDT)