Recreate CCMDB.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "Things go wrong with CCMDB, such as suddenly showing the password on exit. Compact restore sometimes fixed things, but the password one isn't usually fixed that way. Also, other garbage stays behind that isn't addressed. == Steps == * make new Access program * open in exclusive mode and apply password ** file open, browse (to open window that gives exclusive option), * encrypt w password ** file, encrypt, ignore row message == Log == * 2022-10-26 - doing this because..." |
Ttenbergen (talk | contribs) No edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Things go wrong with CCMDB, such as | Things go wrong with CCMDB, such as [[CCMDB.accdb requires password when closing]]. Compact restore sometimes fixed things, but the password one isn't usually fixed that way. Also, other garbage stays behind that isn't addressed. | ||
== Steps == | == Steps == | ||
* make new Access program | * make new Access program | ||
* open in exclusive mode | * open in exclusive mode | ||
** file open, browse (to open window that gives exclusive option), | ** file open, browse (to open window that gives exclusive option), | ||
* encrypt w password | * encrypt w password | ||
** file, encrypt, ignore row message | ** file, encrypt, ignore row message | ||
* change options | |||
** open file, options | |||
** set application title to "Critical Care and Medicine Database Collection Tool" | |||
** Display Form: MainForm | |||
** Document Window Options: Overlapping Windows | |||
** Compact on Close: true | |||
** Possibly set the navigation options to include system and hidden tables for import, but then you might import corrupted things... | |||
* import everything (but hopefully no problems) from old DB | |||
** External data, new datasource, from database, Access | |||
** in each tab, select all | |||
** click options button and select all under import | |||
* add reference to required VBA libraries | |||
** Microsoft Outlook 16.0 Object Library | |||
** Microsoft Excel 16.0 Object Library | |||
* recreate database relationships: run Sub SQL_relations_restorer() | |||
* might be a good time to do a [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]] | |||
== Log == | == Log == | ||
* 2022-10-26 - doing this because of password on close; got error that DB could not find SL EPR Exclusions table, which was deleted some time ago. | * 2022-11-02 - recreated db relationships that were still not restored after most recent recreate | ||
* 2022-10-26 - doing this because of password on close; got error that DB could not find SL EPR Exclusions table, which was deleted some time ago. | |||
== Related articles == | == Related articles == | ||
Latest revision as of 11:22, 16 December 2025
Things go wrong with CCMDB, such as CCMDB.accdb requires password when closing. Compact restore sometimes fixed things, but the password one isn't usually fixed that way. Also, other garbage stays behind that isn't addressed.
Steps
- make new Access program
- open in exclusive mode
- file open, browse (to open window that gives exclusive option),
- encrypt w password
- file, encrypt, ignore row message
- change options
- open file, options
- set application title to "Critical Care and Medicine Database Collection Tool"
- Display Form: MainForm
- Document Window Options: Overlapping Windows
- Compact on Close: true
- Possibly set the navigation options to include system and hidden tables for import, but then you might import corrupted things...
- import everything (but hopefully no problems) from old DB
- External data, new datasource, from database, Access
- in each tab, select all
- click options button and select all under import
- add reference to required VBA libraries
- Microsoft Outlook 16.0 Object Library
- Microsoft Excel 16.0 Object Library
- recreate database relationships: run Sub SQL_relations_restorer()
- might be a good time to do a Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb
Log
- 2022-11-02 - recreated db relationships that were still not restored after most recent recreate
- 2022-10-26 - doing this because of password on close; got error that DB could not find SL EPR Exclusions table, which was deleted some time ago.
Related articles
| Related articles: |