Instruction for converting SQLBase Schema into Access &
   Creating an Empty Access Database through ERWIN

Follow the steps carefully.

1. Come to the IFSM lab

2. Open up the folder that says Main, and double-click on the icon that says Control Panel

3. Double click on ODBC, and select 'MS Access Databases (Access data(*.mdb))'  from the list of options.
    Do *not* choose the other option that says 'MS Access 2.0 Databases'

4. Now, click on the button that says Setup. This will bring you a screen where you have to create a new
    access database

5. Click on the Create Database Button. Now, browse to a directory and create a new access database. Give
    it any name you want

6. There will a dialog box that will pop out, which says that a database has been successfully created. Now, say
    OK to this and close all the open windows

7. Open ERWIN & load your ER - Diagram

8. Goto  Server and select Target Server option that is beneath it

9. Select Access as your Target/Desktop DBMS and say OK. Do not touch any other fields in this window.
    Erwin might bring a dialog box that says,
        "Would you like to convert datatypes from SQLBase to Access. This is not Undoable"
    Say Yes for this

10. Now goto Server again and say Access Schema generation

11. Click on the button that says Generate

12. This will ask you for user name and a password. Leave the field names blank. On the drop-down box that says
      Databases, scroll down and select 'MS Access databases'.
      Do *not* select MS Access 2.0 Databases under this drop-down

13. Say Connect now

14. This creates the requisite tables on the access database.
      (Note: This process may take some time. So, please be patient!!)

15. After you are done with this, come out of ERWIN

16. Open up Access again & open the database you just created. If there's a message that says,
              'Object properties cannot be modified, or something like that - ignore it'

17. Now, start inserting data into each one of your tables. Insert the same data that you'd done on your
      SQLBase database. This step is very user friendly & follow the instructions on the screen

18. Copy the MS-Access database (.mdb file) on your disk, and give it to me for part III. It is HIGHLY recommended to load your access database (the .mdb file) using ACCESS 95/97, and save the database in 95/97 format before giving it to me for PART III. This'll allow you to change your table properties/relationships at a later point in time, while you're doing your PART III of the project. By using the database (.mdb file) that ERWIN created, will not allow you to change your table properties (like redefining a column name, changing the datatypes and stuff).