Dynamic Web Tutorials and Notes

Update 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) - rsUpdateRecords
   
7. Click ‘Insert > Application Objects > Record Update Form’
   
8. In connection select the database you defined in IV
   
9. Select record from rsUpdateRecords
   
10. Unique key column - EmployeeID
    
11. After updating go to ‘success.htm’ (we will make this later)
    
12. Check that all the form fields are linked and formatted correctly
    
13. Click ‘OK’
14. Dreamweaver will make an update form that looks like this:
    
15. Delete EmployeeID – Access does this part automatically
    
16. Save page as ‘Update.asp’
17. Press F12 to view page in browser: