CCMDB.accdb
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.
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. AdditionallBold texty, 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.
Change Log
Starting May 27, 2008 the change log will be stored in the. See CCMDB.mdb Change Log.
For 2009 see Change_Log_2009 for the latest.
TOstryzniuk 23:08, 29 December 2008 (CST)
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)
Additional Info Required
- will break out as separate pages once information has been populated in here.
starting Access
?
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
- 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)