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.

Program Development and Changes

See the Development Documentation Category

DISCUSSION

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

--TOstryzniuk 23:21, 13 March 2009 (CDT):File:MottiGrassGrow.gif

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)

Synching

See Syncing the PDA

Sending Patients

See Sending Patients

Sending your data from access

See Sending Patients

Deleting data on PDA after sending from access

• • Before sending, I check my PDA to see if I have entered all my data.Ensuring info is complete on completed profiles.

Ensure computer is onto regional server. Sync my PDA. In microsoft active sync, check for errors, press ok once scrolled through and no errors. In microsoft active sync, click explore. Double click HandDBase 3. Highlight L logs. Edit-copy, make small. Log into regional server, LHandiBase Click S5. Edit, paste, yes to all. once it hightlights blue, I make it small. Turn off PDA, resync. Check files for errors in microsoft active sync. Click onto new folder. Open with cookies. V_temp studies, checker. If no errors, click edit profiles. Filter on top right corner. Click through completed profiles. Fill in missing data highlighted by yellow. Once all profiles checked complete, close the door. Hit send. Add batch no. Add initials. Check true/false-scroll over lines to ready dates. Click out, click yes to save, approx 5 save's. 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) Template:Discussion

• 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)

~~discussion~~

• 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)

Discussion

• data collectors must participate and fill this information in.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.TOstryzniuk 23:31, 26 February 2009 (CST)
  • Confused, why gather this information when we are expecting lap-tops soon and the process will change?--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. --TOstryzniuk 13:26, 16 March 2009 (CDT)