CCMDB.accdb requires password when closing: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{fixed bug}}
Occasionally after changing something in the programming of [[CCMDB.accdb]] it starts requiring a password on closing.  
Occasionally after changing something in the programming of [[CCMDB.accdb]] it starts requiring a password on closing.  


Line 6: Line 5:


== If this happens during updating of the program by main office ==
== If this happens during updating of the program by main office ==
The only solution seems to be to revert to an earlier version and re-apply the changes that were done. If the changes were extensive it might be quicker to import the module/form/etc that was changed from the corrupted version, but that too can be tricky. This happens to Tina during programming about once a month, but isn't usually encountered by others since they don't work with the code or data structures.
Try [[Reverting back to an older version of CCMDB.accdb]] or possibly [[Recreate CCMDB.accdb]]
* Steps to Identify the latest clean version to revert to:
** In the regional server \\ad.wrha.mb.ca\WRHA\REGION\Shared\ICU_DATA_COLLECTION\Programs\Master\Versions, check the previous versions for one that may be larger than the others, it is usually around 12-13,000 KB, choose the most recent "normal" sized version based on this
** close database if you currently have it open
** copy the clean version and put it on the desktop
** rename to CCMDB.accdb, removing the postfix we apply to old versions
** open this copy and reapply any changes (look at the [[Log]])
** copy this new version from the desktop and put it in the C:\ccmdb_program, overwriting the broken version that is currently there
** follow the usual steps for [[Rolling out changes]]


== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}
[[Category:IT Instructions]]
[[Category:CCMDB.accdb]]

Latest revision as of 12:21, 16 December 2025

Occasionally after changing something in the programming of CCMDB.accdb it starts requiring a password on closing.

If this happens on a data collector laptop

Try Copying down a clean version of CCMDB.accdb.

If this happens during updating of the program by main office

Try Reverting back to an older version of CCMDB.accdb or possibly Recreate CCMDB.accdb

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_requires_password_when_closing&oldid=168158"