EMWAC Database Demonstrator - Access version Installation Notes (Notes on using the demonstrator are in file readme2.txt) The following notes refer to installation of the application to interact with local Microsoft Access databases. This version demonstrates the interface but does not interact with remote databases and so requires none of the communications prerequisites. Software prerequisites ---------------------- The development was done under Windows for workgroups 3.11, Microsoft Access 1.1. Operation in other environments has not been tested. ODBC or other communication components are not required. Hardware Requirements --------------------- The machine used for development was an IBM 486 with 16mb RAM. The application should work however on any PC compatible capable of supporting the software prerequisites. 8mb RAM is the recommended minimum. Because this application emulates remote servers, additional Access databases are required. The total space requirements for Access databases are as follows: Database: Acc91pr.mdb Purpose: Main Access application. Compressed: 146 kb. Uncompressed: 400k of disk memory is required to load the application initially. This will expand; how much depends on how the application is used; 1 mb should generally be sufficient. Database: C91cntrl.mdb Purpose: Access database containing dummy Census data. Compressed: 11 kb. Uncompressed: 65 kb; does not increase in size. Database: C91Dum1.mdb Purpose: Access database 1 containing dummy Census data. Compressed: 670 kb Uncompressed: 2.8mb; does not increase in size. Database: C91Dum2.mdb Purpose: Access database 2 containing dummy Census data. Compressed: 985 kb Uncompressed: 3.3mb; does not increase in size Installation ------------ 1. Application The Access database containing the applications is a normal Access database, contained in a single file and is named accc91p.mdb. It can be installed (by copying it after uncompressing it) in any convenient directory. 2. Dummy server data databases There are three of these databases; c91dum1.mdb and c91dum2.mdb contain dummy census data and c91cntrl.mdb contains control data. All three operate as is they were stored on remote database servers. They can be installed in any convenient directory (after uncompressing them) although the default directory for their installation in c:\access 3. Installing server databases in directories other than c:\access If any or all of the access database files c91dum1.mdb, c91dum2.mdb, or c91cntrl.mdb are installed in a directory other than c:\access, the table "Access Database Names" in the application will have to be updated to point to their new location. (that table does for the Access demonstrator what the ODBC mapping information does for the ODBC demonstrator). To update this table: a. open the database accc91p.mdb WITH THE SHIFT KEY HELD DOWN. The "Database" window should be displaying the Tables in the database. b. Open the table "Access Database Names" by double clicking on the name. The Table's datasheet should be displayed c. Update the "Drive Letter" and "Path" files as required; no other fields should be changed. d. Close the table. e. Close the database. 4. The application can now be opened and started as normal.