Dynamic Web Tutorials and Notes

Insert records

1. File>New
   
2. Select Dynamic Page
   
3. Click ASP VBScript
   
4. Click ‘Create’
5. Create a DSN to your database if necessary (see IV)
6. Create a Recordset (see V) - rsInsertRecords
   
7. Click ‘Insert > Application Objects > Record Insertion Form’
   
8. In connection select the database you defined in IV
   
9. In insert into table select ‘Employees’
   
10. After inserting go to ‘success.htm’ (we will make this later)
    
11. Check that all the form fields are linked and formatted correctly
    
12. If any aren’t, select them and choose the correct element from the drop down menus below
    
13. Click ‘OK’
14. Dreamweaver MX will create an insert page for you:
    
15. Delete ‘EmployeeID’ section as Access does this automatically
    
16. Save page as ‘Insert.asp’
17. Press F12 to view page in browser: