|     home    |     search     |     content     |     mail     |     login     |

physical file information

phys. file code7
location localhla_mdb
location on Bolder serverc:\bolderdata\GGGD\hla\hla.mdb
DB platformAccess 97
location DSNc:\bolderdata\GGGD\hla\hla.dsn
loc. central correctTrue
loc. DSN correctTrue
check date3-jan-2003 15:01
commentThis Access file was made from an SAS data file using the DBMS-copy utility. The original SAS files plus the codebook are also on the server in comressed format (HLASASDataSets.zip) containing Madcam, LTACaco, HLADB and HLADBCC.
resp. centreGGD


This screen displays information about a physical file. A physical file contains one or more tables.
For a file two locations can be given:
  1. the location local, i.e. on a PC, for administrative purposes
  2. the location central: this is the folder on the ACS server were the file is
For a file on the ACS server a Data Source Name (DSN) file can be given. This file specifies how to query the file for data.
If a file is stored on the ACS server, a utility can be run to check if the locations of the file and its corresponding DSN are correct. When this utility is run, the date is stored in field "check date".
  • click on button 'tablelist' to view which tables are in this file
  • click on the DB platform to view more information about the database platform