CCMDB.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
No edit summary
Line 12: Line 12:




[[Category: IT_Instructions]]


==Additional Info Required==
=Additional Info Required=
some of these as separate pages
*will break out as separate pages
*''''' Checking your Data in Access
 
*''''' starting Access
==Checking your Data in Access==
*''''' filtering to complete only
 
*''''' Yellow fields and error messages
 
*''''' Sending your data
==starting Access==
*''''' Deleting data once you have the OK, ...
 
 
==filtering to complete only==
 
 
==Yellow fields and error messages==
 
 
==deleting in ACCESS==
 
 
==the process of sending your data from access==
 
 
==Deleting data after sending from access==
 
 




Line 27: Line 42:
== Discussion ==
== Discussion ==
* data collectors must participate and fill this information in.[[User:TOstryzniuk|TOstryzniuk]] 22:31, 29 October 2008 (CDT)
* data collectors must participate and fill this information in.[[User:TOstryzniuk|TOstryzniuk]] 22:31, 29 October 2008 (CDT)
**ATTENTION all Data collectors: Can you please contribute to the above information in regards to the steps above for 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 the above steps that collector follow.[[User:TOstryzniuk|TOstryzniuk]] 23:31, 26 February 2009 (CST)




{{stub}}
{{stub}}
[[Category:IT Instructions]]
[[Category:IT Instructions]]

Revision as of 23:31, 2009 February 26

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. Additionally, 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)


Additional Info Required

  • will break out as separate pages

Checking your Data in Access

starting Access

filtering to complete only

Yellow fields and error messages

deleting in ACCESS

the process of sending your data from access

Deleting data after sending from access

Template:Discussion

Discussion

  • data collectors must participate and fill this information in.TOstryzniuk 22:31, 29 October 2008 (CDT)
    • ATTENTION all Data collectors: Can you please contribute to the above information in regards to the steps above for 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 the above steps that collector follow.TOstryzniuk 23:31, 26 February 2009 (CST)


Template:Stub