CCMDB.accdb requires password when closing: Difference between revisions

No edit summary
 
(4 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 Clean Verion and revert to an earlier clean version
** 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 clean version based on this
** once identified copy the clean version and put it on the desktop, make sure you don't have the database open
** rename to CCMDB.accdb
** open this copy and reapply any changes (look at the CCMDB change log)
** copy this new version from the desktop and put it in the C:\ccmdb_program
** follow the usual steps for [[Rolling out changes]]


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