Recreate CCMDB.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Steps |
Ttenbergen (talk | contribs) m →Steps |
||
| Line 3: | Line 3: | ||
== 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 | ||
* 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 | |||
* change options | * change options | ||
** open file, options | ** open file, options | ||
Revision as of 15:16, 26 October 2022
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
- file open, browse (to open window that gives exclusive option),
- encrypt w password
- file, encrypt, ignore row message
- 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
- 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
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.
Related articles
| Related articles: |