Changing a Laptop identifier

The location of a laptop (set in Settings.mdb) has a bearing on various cross checks, output locations etc. Therefore, to change it all the related things need to be accounted for.

Check List

• confirm with the statistician whether there is impact

• CCMDB.mdb which feeds CFE tables
  • table S Locations
  • table s_locations_allowed_collection
  • for medicine, table s_tmp_er_wait_r_locations
  • possibly table s_varOptions if new Var 1 - Admit-from Ward/Var 2 - Discharge-to Ward are required
  • possibly table S Tmp
  • find/search through all VBA modules for the new name, the current name, possible equivalent unit name
  • make sure that the location name is not relevant to any of the queries; I can't think of a nice way to automate this.

• batch files
  • set News and backup/Batstart.bat to new location
  • test n&b to make sure new location and directory name don't break anything
  • update locs.bat
  • create/update Data to local.bat

• directory structures
  • add a folder regional_server\programs\<new name> (rather than re-name, to facilitate backing out if we can’t finish)
  • add a folder regional server\data\<new name>

• local laptop settings
  • set A_Info/Settings (CCMBD.mdb) to new location
  • test sending to make sure new location and directory name don't break anything

• CFE
  • anything?

• workstations.mdb - add new location, shuold probably make this directory based just like Transfer Tracker.mdb