Database problem solving page

1. Relinking the database:
    Needed every time new cheklists are added or the path is changed. It never hurts to try anyway! For a new table, it is only necessary to link the new one.

• highlight the interface.mdb file, hold down the shift key, double-click on it
• select the first file with a fat arrow to the left - hit "delete" and "CR" to accept default option; remove all links. This step might not be necessary if John has just sent an upgraded DB.
• go under file / external data / link tables
• with the browse, going under My Computer, select  \\TRT-Barrel5\CERN Barrel DB\CERNDB2000.mdb (the full address is needed for users opening the database over the network but not when working directly from trt-barrel5)
• click link
• select all - don't click OK
• scroll to the top of the list and un-select the first few entries, all those without tbly and the first one called with some bogus name: tblyaCERN-Tables-follow
• click OK, close and re-open normally

• first, kill the database process using the task manager if the database is stuck
• then look into the CERN Barrel DB folder for files with ldb suffix
• delete these ldb files (locked db)
• resume normally

• highlight the interface.mdb file, hold down the shift key, double-click on it
• select "Tables" from the left column list
• open the tblDataBaseLink file (towards the end)
• insert the proper and full path in there
• (at CERN: \\TRT-Barrel5\CERN Barrel DB\CERNDB2000.mdb)
• relink the database as in  #1 above

• check the privileges for that interface using the right mouse button / properties / security
• un-check the "allow inheritance box"
• click on "copy" in the pop-up window saying you want the same options as the top folder
• check the "allow inheritance" box
• click on apply: the allowed user list will appear

•  the file is in the CERN Barrel DB folder
• the file ftp_CERN does all the operations
• right click on it /open with / notepad to edit it
• the transfer of interfaces are disabled since it would overwrite the path set for CERN (see step #3 above about wrong paths).
• the file ftp_CERN_interface contains the commands to transfer the interfaces if needed
• these tasks are done by the scheduler

• settings/ control panel / scheduled tasks / add : for a new task and follow the wizard
• or as above and click on any scheduled tasks to see the details, like which command file is executed
• to test a new set of command file: start / programs / accessories / command prompt
• connect to the computer you want
• test the commands on the command line

• Open the CERNDB2000.mdb; copy and paste (structure only) an existing checklist
• Modify the tblyChecklistNames to include the new name; re-number by hand
• Give John a call so he can make one small necessary adjustment.

• Open the CERNDB2000.mdb; delete the unwanted checklists
• Modify the tblyChecklistNames to remove the old checklist names; re-number by hand

• Make sure the checklists has at least one entry
• Also check to see if all the steps are properly ordered.

• The step where it crashed had no selection (done or accept) for the correct answer.
• Editing the checklist fixed it after deleting the .ldb file created with error 91.

11. Deleting or fixing typos in collected data

• Open the CERNDB2000.mdb
• Select Tables under the Objects list to the left
• Double click on the desired table where the data is stored:

  tblyCompletedModules: for all information recorded with a checklist

  tblyDataModuleDimensions: for the dimensions

  tblyData16ch: for data collected with the 16-channel data tester etc.

• If you delete records; they will be lost for ever. So make sure you know what you are doing!
• Using the Edit/Find command, click on the replace tab
• Click on the column where you want to modify something and use the replace all option after selecting the string to replace. The single replace button only works if one field is selected.