Importing CCMDB.accdb into a new .accdb

These are just some notes for Tina, probably not relevant to anyone else.

.accdb files occasionally become corrupted and bloated. Compact and Repair only deals with some of it, so another recommended solution is to import all the contents of a db into a new, clean DB. Some settings do not travel across with this import, so this is a checklist of what else needs to be done when importing into a new .accdb.

Steps

1. set up new db
2. import all tables etc
3. set password
4. set current database options
   • compact-on-close
   • database title "Critical Care and Medicine Database"
   • display form "Main Form"
5. close
6. open in exclusive mode, set password (ignore row... cipher... warning)

Related articles

Related articles:

CCMDB.accdb Change Log 2020 (← links)