Tutorial on Exercise 1 using ASP

A very Simple Tutorial  for exercise 1.

 From seven steps..i narrow it down and combine some of the steps


1st - create database using Microsoft Access, and please make sure you save as  it at lower version of Access..For example : Save as Microsoft Access 2000-2003 version.
Note: Make sure save it to c : inetpub/wwwroot directory

2nd part 1 - Create site

Follow all the steps from the hands out given..
note:

• please create new folder with your site name at the  c : inetpub/wwwroot directory
• Change the security of the folder (right click and choose properties)

folder properties

• Click edit 
• Click add
• click advanced
• Find "everyone"

• Add up "everyone" and tick all the box - for full authority to modify anything

Step 2 part 2 -create connection to dbase

• Choose databases and click plus sign
• Choose Data Source Name

Need to click the User DSN, System DSN and File DSN tab
Generally you need to click as below..

• Click define
• Choose system DSN tab 
• Click add

Choose Microsft Access Driver (Note: choose carefully)

For File DSN - need to give the correct directory to your database

After make the connection, the connection will appear as well as the table1.This is a successful connection.

Step 3 -Create two asp pages as per requested by the exercise1 handout.

• register form - use text ,text field and button  
• view form-

Use table inside the form for both pages.

(Note: save it to the same directory  c : inetpub/wwwroot directory/yoursitename

For register form - need to use insert record function

For view form -need to use recordset and repeatregion function

(note: refer to your handouts from week 4)

Lastly: testing your page using browser

Good Luck :)