FP98: How to Post Information to a Microsoft Access Database Using ASP

Posting Information to a Microsoft Access Database Using ASP

1. Start Microsoft Access 97 and follow these steps:
   
   
   1. Create a database that includes one table. Name the table "Employees" (without the quotation marks).
   2. Insert four fields and name them as follows:
      
      EmployeesID
      FirstName
      LastName
      EmailName
   3. On the File menu, click Save. In the File Name box, type "Aspsamp.mdb" (without the quotation marks), and click Save.
2. Start FrontPage Explorer and create a new Web by following these steps:
   
   
   1. On the File menu, point to New, and click FrontPage Web.
   2. In Step 1, click One Page Web.
   3. In Step 2, click Change.
   4. In the "Please specify a location of the New FrontPage Web" box, type the following:

      http://localhost/ASPWeb

   5. In the "Choose a title for your FrontPage Web" box, type "ASPWeb" (without the quotation marks).
   6. Click OK twice.
3. On the View menu, click Folders.
4. Import the Microsoft Access 97 database file into FrontPage Explorer. To do this, follow these steps:
   
   
   1. On the File menu, click Import.
   2. Click Add File.
   3. Click Browse, select the file you created in step 1, and then click Open.
   4. Click OK.
5. Create an executable folder by following these steps:
   
   
   1. On the File Menu, point to New, and click Folder.
   2. Name the folder "ASP" (without the quotation marks).
   3. Press ENTER.
   4. Right-click the ASP folder and click Properties on the menu that appears.
   5. Click to select the "Allow scripts or programs to be run" check box.
   6. Click OK.
6. Create a system Data Source Name (DSN) by following these steps:
   
   
   1. On the Windows Start menu, point to Settings, and then click Control Panel.
   2. Double-click the 32bit ODBC icon (Windows 95) or the ODBC icon (Windows NT).
      
      In Windows 2000, double-click Administrative Tools, and double-click Data Sources (ODBC).
   3. Click the System DSN tab.
   4. Click Add.
   5. Select the driver you want to use. For example, select "Microsoft Access Driver (*.mdb)." Click Finish.
   6. In the Data Source Name box, type the name you want. For example, type "Aspdemo" (without the quotation marks). Note that the DSN name should not include any spaces.
   7. Click Select.
   8. Select the database file you want to use (for example, select Aspsamp.mdb). The file will be located in one of the following IIS Web server locations:
      
      
      • Personal Web Server for Windows 95:
        
        C:\Webshare\Wwwroot\Aspweb\Aspsamp.mdb
      • Internet Information Server for Windows NT Server/Windows 2000:
        
        C:\InetPub\Wwwroot\Aspweb\Aspsamp.mdb
      • Microsoft Peer Web Services for Windows NT Workstation:
        
        C:\InetPub\Wwwroot\Aspweb\Aspsamp.mdb
   9. Click OK three times.
7. Create a form that contains three one-line text boxes:
   
   
   1. In FrontPage Explorer, double-click the Default.htm file.
      
      The file will be opened in FrontPage Editor.
   2. On the Insert menu, point to Form Field, and click One-Line Text Box.
      
      NOTE: When you insert the first form field, the Submit and Reset buttons will be present on the form. These will appear to the right of the form field. If you want to move these buttons to a new line in the form, click in front of the first form field and then press ENTER.
   3. Click to the left of the one-line text box form field.
   4. Type "First Name:" (without the quotation marks).
   5. Select the text box and the text that you typed in step d.
   6. On the Insert menu, point to Form Field, and click Label.
   7. Right-click the one-line text box and then click Form Field Properties on the menu that appears.
   8. In the Name box, type "FirstName" (without the quotation marks). Click OK.
   9. Press the RIGHT ARROW key and then press ENTER.
   10. On the Insert menu, point to Form Field, and click One-Line Text Box.
   11. Repeat steps b through i for the remaining two fields (LastName and EmailName).
   12. Right-click the Submit button and then click Form Properties on the menu that appears.
   13. Click Send To Other and select the "Custom ISAPI, NSAPI, CGI, or ASP Script" option in the Send To Other list.
   14. Click Options.
   15. In the "Options for Custom Form Handler" dialog box, in the Action box, type "ASP/posts.asp" (without the quotation marks).
   16. Click OK twice.
   17. On the File menu, click Save.
8. In FrontPage Editor, create the ASP page by following these steps:
   
   
   1. On the File menu, click New, and then click the Page tab.
   2. Double-click Normal Page.
   3. On the Insert menu, point to Database, and click Database Region Wizard.
   4. In the "ODBC Data Source Name (DSN)" box, type "ASPDemo" (without the quotation marks). Click Next.
   5. In the "Enter the SQL string for the query" box, type the following SQL code:

      Insert into Employees (FirstName, LastName, EmailName) values
               ('%%FirstName%%','%%LastName%%','%%EmailName%%')
      								

      NOTE: The field names, FirstName, LastName, and EmailName, represent the fields used in the Aspsamp.mdb file. The fields, %%FirstName%%, %%LastName%%, and %%EmailName%% represent the one-line text box form fields.
      
      Click Next.
   6. Click Add Field.
   7. In the Add Field dialog box, type "EmployeesID" (without the quotation marks). Click OK.
   8. Repeat Steps f and g for each of the remaining fields (FirstName, LastName, and EmailName) that you created in step 1.
   9. Click Finish.
   10. Click OK.
   11. On the File menu, click Save. In the Save As dialog box, select the ASP folder you created in step 5. In the File name box, type "posts.asp" (without the quotation marks) and click Save.
9. Open the page in your Web browser, fill in the form fields, and submit the form.
   
   NOTE: After you click Submit, you will receive a "No Records Returned" message. Start or switch to Microsoft Access and open the Aspsamp.mdb file. Note that new information will have been added to the database.
   
   For more information, please see the following article in the Microsoft Knowledge Base:

   182122 How to Remove or Customize the 'No Records Returned' Message