FP2000: How to Delete a Record from Microsoft Access 2000

• Microsoft FrontPage 2000

SUMMARY

This article describes how to delete a record from a Microsoft Access 2000 database by using FrontPage 2000 and Active Server Pages (ASP).

MORE INFORMATION

Getting Ready to Use the ASP Features in FrontPage 2000

• A 32-bit ODBC driver



• An ASP-compatible server, such as one of the following servers:
  • Microsoft Internet Information Server (IIS) version 3.0 or 4.0 for Microsoft Windows NT Server
  
  
  
  • Microsoft Peer Web Services for Microsoft Windows NT Workstation
  
  
  
  • Microsoft Personal Web Server for Microsoft Windows 95 with the ASP engine added
  
  
  
  • Microsoft Personal Web Server 4.0
  
  
  



• FrontPage 2000 Server Extensions

How to Delete a Record in a Microsoft Access Database Using ASP

1. Start Microsoft FrontPage 2000 and create a new web (on the File menu, click New and then click Web). In the Specify the location of the new web box, type http://localhost/aspsample, and click the Web site default of One Page Web.



2. On a new page, on the Insert menu, point to Database, and click Results.



3. In Step 1, select the Use a sample database connection (Northwind) check box, and click Next.



4. In Step 2, select Employees as the Record Source, and then click Next.



5. In Step 3, click Next.



6. In Step 4, select List - one field per item in the Formatting list and Text fields in the List options list, and then click Next.



7. In Step 5, click Split records into groups, and type 1 in the Records per group box. Click Finish.



8. Double-click the Submit button, and change the Value/Label field to Delete.



9. Right-click inside the form, and click Form Properties.



10. In Form Properties, click the Send to other button, and then click Options.



11. In the Action field, type Delete.asp. Click OK twice and then save the page as Delete_Form.asp.



12. Create a new page. (On the File menu, point to New, click Page, and click Normal Page.)



13. On the Insert menu, point to Database, and click Results.



14. In Step 1, click the Use an existing database connection button, and select ASPsample. Click Next.



15. In Step 2, click the Custom query button, and then click Edit. In the SQL statement window, type the following SQL code:

    Delete Distinctrow FirstName from Employees where FirstName='%%FirstName%%' and LastName='%%LastName%%'

    Click OK and then click Next.



16. In Step 3, click Next.



17. In Step 4, select Table-One Record Per Row and then click Next.



18. In Step 5, make sure the Add search form check box is not selected. Click Finish and then save the page as Delete.asp.

Additional query words: front page

Keywords : kbdta fpse2000
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbinfo