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).