Importing CCMDB.accdb into a new .accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(Created page with "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...")
 
 
(4 intermediate revisions by the same user not shown)
Line 6: Line 6:
# set up new db
# set up new db
# import all tables etc
# import all tables etc
# set password
# set current database options
# set compact-on-close
#* compact-on-close
#* database title "Critical Care and Medicine Database"
#* display form "Main Form"
#* Document Window Options "Overlapping Windows"
# add VBA tools references:
#* Microsoft Excel 16.0 Object Library (used by converters function age)
#* Microsoft Visual Basic for Applications Extensibility 5.3 '''(can't remember what for, leaving out for now...)'''
#* Microsoft ADO Ext. 6.0 for DDL and Security '''(can't remember what for, leaving out for now...)'''
# close
# open in exclusive mode, set password (ignore row... cipher... warning)


== Related articles ==  
== Related articles ==  
Line 13: Line 22:




[[Category:IT instructions]]
[[Category:IT Instructions]]

Latest revision as of 11:48, 2023 January 17

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 current database options
    • compact-on-close
    • database title "Critical Care and Medicine Database"
    • display form "Main Form"
    • Document Window Options "Overlapping Windows"
  4. add VBA tools references:
    • Microsoft Excel 16.0 Object Library (used by converters function age)
    • Microsoft Visual Basic for Applications Extensibility 5.3 (can't remember what for, leaving out for now...)
    • Microsoft ADO Ext. 6.0 for DDL and Security (can't remember what for, leaving out for now...)
  5. close
  6. open in exclusive mode, set password (ignore row... cipher... warning)

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Importing_CCMDB.accdb_into_a_new_.accdb&oldid=158286"