Hi there
I have created a simple form for my assignment in Front Page(FP) Which has to submit info to a MDB file
MDB file was created by FP its self. the thing is when i click submit it gives me a successful submit confirmation but when i open the DB file there is no entry

what is the problem
I am Using a IIS server to test XP base

are there any other tools to make forms with db link


ASP Form code below

<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Session.LCID = 1033
Err.Clear

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
	Err.Clear

	Set fp_conn =  Server.CreateObject("ADODB.Connection")
	FP_DumpError strErrorUrl, "Cannot create connection"

	Set fp_rs = Server.CreateObject("ADODB.Recordset")
	FP_DumpError strErrorUrl, "Cannot create record set"

	fp_conn.Open Application("enrol_ConnectionString")
	FP_DumpError strErrorUrl, "Cannot open database"

	fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
	FP_DumpError strErrorUrl, "Cannot open record set"

	fp_rs.AddNew
	FP_DumpError strErrorUrl, "Cannot add new record set to the database"
	Dim arFormFields0(38)
	Dim arFormDBFields0(38)
	Dim arFormValues0(38)

	arFormFields0(0) = "Sex"
	arFormDBFields0(0) = "Sex"
	arFormValues0(0) = Request("Sex")
	arFormFields0(1) = "Enrollment_No"
	arFormDBFields0(1) = "Enrollment_No"
	arFormValues0(1) = Request("Enrollment_No")
	arFormFields0(2) = "First_Name"
	arFormDBFields0(2) = "First_Name"
	arFormValues0(2) = Request("First_Name")
	arFormFields0(3) = "e_mail"
	arFormDBFields0(3) = "e_mail"
	arFormValues0(3) = Request("e_mail")
	arFormFields0(4) = "Year1"
	arFormDBFields0(4) = "Year1"
	arFormValues0(4) = Request("Year1")
	arFormFields0(5) = "DD_Date"
	arFormDBFields0(5) = "DD_Date"
	arFormValues0(5) = Request("DD_Date")
	arFormFields0(6) = "P_G_C1"
	arFormDBFields0(6) = "P_G_C1"
	arFormValues0(6) = Request("P_G_C1")
	arFormFields0(7) = "Year2"
	arFormDBFields0(7) = "Year2"
	arFormValues0(7) = Request("Year2")
	arFormFields0(8) = "P_G_C2"
	arFormDBFields0(8) = "P_G_C2"
	arFormValues0(8) = Request("P_G_C2")
	arFormFields0(9) = "Year3"
	arFormDBFields0(9) = "Year3"
	arFormValues0(9) = Request("Year3")
	arFormFields0(10) = "Last_Name"
	arFormDBFields0(10) = "Last_Name"
	arFormValues0(10) = Request("Last_Name")
	arFormFields0(11) = "P_G_C3"
	arFormDBFields0(11) = "P_G_C3"
	arFormValues0(11) = Request("P_G_C3")
	arFormFields0(12) = "Qualification_code1"
	arFormDBFields0(12) = "Qualification_code1"
	arFormValues0(12) = Request("Qualification_code1")
	arFormFields0(13) = "University_Board1"
	arFormDBFields0(13) = "University_Board1"
	arFormValues0(13) = Request("University_Board1")
	arFormFields0(14) = "Zip_Pin"
	arFormDBFields0(14) = "Zip_Pin"
	arFormValues0(14) = Request("Zip_Pin")
	arFormFields0(15) = "Qualification_code2"
	arFormDBFields0(15) = "Qualification_code2"
	arFormValues0(15) = Request("Qualification_code2")
	arFormFields0(16) = "University_Board2"
	arFormDBFields0(16) = "University_Board2"
	arFormValues0(16) = Request("University_Board2")
	arFormFields0(17) = "City"
	arFormDBFields0(17) = "City"
	arFormValues0(17) = Request("City")
	arFormFields0(18) = "Qualification_code3"
	arFormDBFields0(18) = "Qualification_code3"
	arFormValues0(18) = Request("Qualification_code3")
	arFormFields0(19) = "University_Board3"
	arFormDBFields0(19) = "University_Board3"
	arFormValues0(19) = Request("University_Board3")
	arFormFields0(20) = "DD_No"
	arFormDBFields0(20) = "DD_No"
	arFormValues0(20) = Request("DD_No")
	arFormFields0(21) = "Main_Subjects1"
	arFormDBFields0(21) = "Main_Subjects1"
	arFormValues0(21) = Request("Main_Subjects1")
	arFormFields0(22) = "F_M_H_Name"
	arFormDBFields0(22) = "F_M_H_Name"
	arFormValues0(22) = Request("F_M_H_Name")
	arFormFields0(23) = "Socia_Status"
	arFormDBFields0(23) = "Socia_Status"
	arFormValues0(23) = Request("Socia_Status")
	arFormFields0(24) = "Main_Subjects2"
	arFormDBFields0(24) = "Main_Subjects2"
	arFormValues0(24) = Request("Main_Subjects2")
	arFormFields0(25) = "HND"
	arFormDBFields0(25) = "HND"
	arFormValues0(25) = Request("HND")
	arFormFields0(26) = "DD_Amt"
	arFormDBFields0(26) = "DD_Amt"
	arFormValues0(26) = Request("DD_Amt")
	arFormFields0(27) = "Main_Subjects3"
	arFormDBFields0(27) = "Main_Subjects3"
	arFormValues0(27) = Request("Main_Subjects3")
	arFormFields0(28) = "Bank_Name"
	arFormDBFields0(28) = "Bank_Name"
	arFormValues0(28) = Request("Bank_Name")
	arFormFields0(29) = "Program_Code"
	arFormDBFields0(29) = "Program_Code"
	arFormValues0(29) = Request("Program_Code")
	arFormFields0(30) = "Date_of_Birth"
	arFormDBFields0(30) = "Date_of_Birth"
	arFormValues0(30) = Request("Date_of_Birth")
	arFormFields0(31) = "Country"
	arFormDBFields0(31) = "Country"
	arFormValues0(31) = Request("Country")
	arFormFields0(32) = "Marital_Status"
	arFormDBFields0(32) = "Marital_Status"
	arFormValues0(32) = Request("Marital_Status")
	arFormFields0(33) = "Address"
	arFormDBFields0(33) = "Address"
	arFormValues0(33) = Request("Address")
	arFormFields0(34) = "State"
	arFormDBFields0(34) = "State"
	arFormValues0(34) = Request("State")
	arFormFields0(35) = "Category"
	arFormDBFields0(35) = "Category"
	arFormValues0(35) = Request("Category")
	arFormFields0(36) = "Middle_Name"
	arFormDBFields0(36) = "Middle_Name"
	arFormValues0(36) = Request("Middle_Name")
	arFormFields0(37) = "Nationality"
	arFormDBFields0(37) = "Nationality"
	arFormValues0(37) = Request("Nationality")

	FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

	If Request.ServerVariables("REMOTE_HOST") <> "" Then
		FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name"
	End If
	If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
		FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type"
	End If
	FP_SaveFieldToDB fp_rs, Now, "Timestamp"
	If Request.ServerVariables("REMOTE_USER") <> "" Then
		FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name"
	End If

	fp_rs.Update
	FP_DumpError strErrorUrl, "Cannot update the database"

	fp_rs.Close
	fp_conn.Close

	FP_FormConfirmation "text/html; charset=windows-1252",_
						"Form Confirmation",_
						"Thank you for submitting the following information:",_
						"enrol.asp",_
						"Return to the form."

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Program Code</title>
<style>
<!--
 table.MsoNormalTable
	{mso-style-parent:"";
	font-size:10.0pt;
	font-family:"Times New Roman"}
-->
</style>
</head>

<body bgcolor="#FFFFD5">

<form method="POST" action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
  <!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="enrol" S-RecordSource="Results" U-Database-URL="fpdb/enrol6.mdb" S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER" S-Builtin-DBFields="Browser_type Remote_computer_name Timestamp User_name" S-Form-Fields="Sex First_Name Enrollment_No e_mail DD_Date Year1 Year2 P_G_C1 Year3 P_G_C2 P_G_C3 Last_Name University_Board1 Qualification_code1 University_Board2 Qualification_code2 Zip_Pin DD_No University_Board3 Qualification_code3 City Main_Subjects1 DD_Amt HND Main_Subjects2 Socia_Status F_M_H_Name Bank_Name Main_Subjects3 Program_Code Marital_Status Country Date_of_Birth Category State Address Nationality Middle_Name" S-Form-DBFields="Sex First_Name Enrollment_No e_mail DD_Date Year1 Year2 P_G_C1 Year3 P_G_C2 P_G_C3 Last_Name University_Board1 Qualification_code1 University_Board2 Qualification_code2 Zip_Pin DD_No University_Board3 Qualification_code3 City Main_Subjects1 DD_Amt HND Main_Subjects2 Socia_Status F_M_H_Name Bank_Name Main_Subjects3 Program_Code Marital_Status Country Date_of_Birth Category State Address Nationality Middle_Name" --><p>
  <b><font color="#000080">Program Code:</font> </b>
  <!--webbot bot="Validation" s-display-name="Program Code" s-data-type="String" b-allow-letters="TRUE" b-value-required="TRUE" i-minimum-length="3" i-maximum-length="3" --><input type="text" name="Program_Code" size="4" value="BIT" maxlength="3">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <b><font color="#000080">Enrollment No.:</font></b><!--webbot bot="Validation" s-display-name="Enrollment No." s-data-type="Number" s-number-separators="x." b-value-required="TRUE" i-minimum-length="9" i-maximum-length="9" --><input type="text" name="Enrollment_No" size="9" maxlength="9"></p>
  <p>&nbsp;</p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <font color="#000080"><b>Last Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  First Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  Middle Name</b></font></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Last Name" s-data-type="String" b-allow-letters="TRUE" b-value-required="TRUE" i-minimum-length="3" --><input type="text" name="Last_Name" size="20">&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="First Name" s-data-type="String" b-allow-letters="TRUE" b-value-required="TRUE" i-minimum-length="3" --><input type="text" name="First_Name" size="20">&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Middle Name" s-data-type="String" b-allow-letters="TRUE" --><input type="text" name="Middle_Name" size="20"></p>
  <p><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <font color="#000080">Father's / Mother's / Husband's Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  Date of Birth</font></b></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Father's/ Mother's/ Husband's Name" s-data-type="String" b-allow-letters="TRUE" b-allow-whitespace="TRUE" b-value-required="TRUE" i-minimum-length="3" --><input type="text" name="F_M_H_Name" size="36">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Date of Birth" s-data-type="String" b-allow-digits="TRUE" s-allow-other-chars="/" b-value-required="TRUE" i-minimum-length="10" i-maximum-length="10" --><input type="text" name="Date_of_Birth" size="20" value="dd/mm/yyyy" maxlength="10"></p>
  <p><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  <font color="#000080">Address:</font></b></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" b-value-required="TRUE" --><textarea rows="5" name="Address" cols="51"></textarea></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  <b><font color="#000080">City&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  State&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
   
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Zip/Pin Code.</font></b></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="City" s-data-type="String" b-allow-letters="TRUE" b-value-required="TRUE" i-minimum-length="3" --><input type="text" name="City" size="20">&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="State" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="State">
  <option>Select</option>
  <option value="01">Andhra Pradesh</option>
  <option value="02">Andaman &amp; Nicobar Islands (UT)</option>
  <option value="03">Arunachal Pradesh</option>
  <option value="04">Assam</option>
  <option value="05">Bihar</option>
  <option value="06">Chandigarh (UT)</option>
  <option value="07">Delhi</option>
  <option value="08">Goa</option>
  <option value="09">Gujarat</option>
  <option value="10">Haryana</option>
  <option value="11">Himachal Pradesh</option>
  <option value="12">Jammu &amp; Kashmir</option>
  <option value="13">Karnataka</option>
  <option value="14">Kerala</option>
  <option value="15">Madhya Pradesh</option>
  <option value="16">Maharashtra</option>
  <option value="17">Manipur</option>
  <option value="18">Meghalaya</option>
  <option value="19">Mizoram</option>
  <option value="20">Nagaland</option>
  <option value="21">Orissa</option>
  <option value="22">Punjab</option>
  <option value="23">Rajasthan</option>
  <option value="24">Sikkim</option>
  <option value="25">Tamil Nadu</option>
  <option value="26">Tripura</option>
  <option value="27">Uttar Pradesh</option>
  <option value="28">West Bengal</option>
  <option value="29">Dadra & Nagar Haveli, Daman & Diu (UT)</option>
  <option value="30">Lakshadweep (UT)</option>
  <option value="31">Pondicherry (UT)</option>
  <option value="32">C/o 56 APO</option>
  <option value="33">C/o 99 APO</option>
  <option value="34">Students Abroad</option>
  <option value="35">Uttaranchal</option>
  <option value="36">Jharkhand</option>
  <option value="37">Chhattisgarh</option>      
  </select>&nbsp;&nbsp;&nbsp;<!--webbot bot="Validation" s-display-name="Zip/Pin" s-data-type="String" b-allow-digits="TRUE" b-value-required="TRUE" i-minimum-length="4" --><input type="text" name="Zip_Pin" size="20">&nbsp;&nbsp;&nbsp; </p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b><font color="#000080">County&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></b>&nbsp;<b><font color="#000080">&nbsp; 
  Nationality&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  E-mail</font></b></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Country" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Country">
  <option>Select</option>
  <option value="001">India</option>
  <option value="002">USA</option>
  <option value="003">Dubai</option>
  <option value="004">UAE</option>
  <option value="005">Sri Lanka</option>
  <option value="006">Bangladesh</option>
  <option value="007">Pakistan</option>
  <option value="008">Kenya</option>
  <option value="009">Kuwait</option>
  <option value="010">Canada</option>
  <option value="011">Others</option>
  </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Nationality" s-data-type="String" b-allow-letters="TRUE" b-value-required="TRUE" i-minimum-length="3" --><input type="text" name="Nationality" size="20">&nbsp;&nbsp;&nbsp;<!--webbot bot="Validation" s-display-name="e-mail" b-value-required="TRUE" --><input type="text" name="e_mail" size="20"></p>
  <p>
  <b><font color="#000080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  Category Territory&nbsp;&nbsp;&nbsp; Marital Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  Social Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  Sex</font></b></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Category" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Category">
  <option value="1">SC</option>
  <option value="2">ST</option>
  <option value="3">OBC</option>
  <option value="4">PH</option>
  <option value="5">General</option>
  <option selected>Select</option>
  </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Marital Status" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Marital_Status">
  <option>Select</option>
  <option value="1">Married</option>
  <option value="2">Divorced</option>
  <option value="3">Widowed</option>
  <option value="4">Unmarried</option>
  </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Social Status" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Socia_Status">
  <option>Select</option>
  <option value="1">Wards of Ex-Service Man</option>
  <option value="2">War-Widow</option>
  <option value="3">Not Applicable</option>
  </select>&nbsp;&nbsp;&nbsp;&nbsp;
  <!--webbot bot="Validation" s-display-name="Sex" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Sex">
  <option>Select</option>
  <option value="Male">M</option>
  <option value="Female">F</option>
  </select></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <font color="#000080">
  <span style="font-family: Times New Roman; font-weight: 700">&nbsp; 
  Qualification Details</span></font></p>
  <table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; border: medium none; margin-left: .45in" width="818" height="119">
    <tr style="page-break-inside: avoid; height: 15.0pt">
      <td style="width: 171; height: 15; border: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="center">
      <p class="MsoNormal" align="center"><b>
      <font size="3">&nbsp;Qualification
      Code</font></b></td>
      <td style="width: 181; height: 15; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="center">
      <p class="MsoNormal" align="center" style="text-align: center"><b>
      <font size="3">Main Subjects</font></b></p>
      </td>
      <td style="width: 55; height: 15; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="center">
      <p class="MsoNormal" align="center" style="text-align: center"><b>
      <font size="3">Year</font></b></td>
      <td style="width: 109; height: 15; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="center">
      <p class="MsoNormal" align="center" style="text-align: center; margin-top:0; margin-bottom:0"><b>
      <font size="3">Percentage/</font></b><p class="MsoNormal" align="center" style="text-align: center; margin-top:0; margin-bottom:0"><b>
      <font size="3">grade/ credit</font></b></td>
      <td style="width: 237; height: 15; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="center">
      <p class="MsoNormal" align="center" style="text-align: center"><b>
      <font size="3">University / Board<br>
      &nbsp;</font></b></td>
    </tr>
    <tr style="page-break-inside: avoid; height: 30.5pt">
      <td valign="top" style="width: 171; height: 20; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-display-name="Qualification Code" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Qualification_code1">
      <option>Select</option>
      <option value="002">10+2 or Equivalent</option>
      <option value="005">Graduation or Equivalent</option>
      <option value="006">Post Graduation or Equivalent</option>
      </select></span></u></td>
      <td valign="top" style="width: 181; height: 20; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-display-name="Main Subjects" s-data-type="String" b-allow-letters="TRUE" b-allow-whitespace="TRUE" s-allow-other-chars="/" b-value-required="TRUE" --><input type="text" name="Main_Subjects1" size="25"></span></u></td>
      <td valign="top" style="width: 55; height: 20; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: center"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-data-type="String" b-allow-digits="TRUE" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="4" --><input type="text" name="Year1" size="9" maxlength="4"></span></u></td>
      <td valign="top" style="width: 109; height: 20; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE" s-allow-other-chars="%" b-value-required="TRUE" i-minimum-length="1" --><input type="text" name="P_G_C1" size="14"></span></u></td>
      <td valign="top" style="width: 237; height: 20; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;</span></u><b><font size="3"><!--webbot bot="Validation" s-display-name="University/ Board" s-data-type="String" b-allow-letters="TRUE" b-allow-whitespace="TRUE" b-value-required="TRUE" i-minimum-length="5" --><input type="text" name="University_Board1" size="27"></font></b></td>
    </tr>
    <tr style="page-break-inside: avoid; height: 30.5pt">
      <td valign="top" style="width: 171; height: 23; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-display-name="Qualification Code" b-disallow-first-item="TRUE" --><select size="1" name="Qualification_code2">
      <option>Select</option>
      <option value="000">NA</option>
      <option value="002">10+2 or Equivalent</option>
      <option value="005">Graduation or Equivalent</option>
      <option value="006">Post Graduation or Equivalent</option>
      </select></span></u></td>
      <td valign="top" style="width: 181; height: 23; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-display-name="Main Subjects" s-data-type="String" b-allow-letters="TRUE" b-allow-whitespace="TRUE" s-allow-other-chars="/" b-value-required="TRUE" --><input type="text" name="Main_Subjects2" size="25" value="NA"></span></u></td>
      <td valign="top" style="width: 55; height: 23; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: center"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-data-type="String" b-allow-digits="TRUE" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="4" --><input type="text" name="Year2" size="9" maxlength="4" value="0000"></span></u></td>
      <td valign="top" style="width: 109; height: 23; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE" s-allow-other-chars="%" b-value-required="TRUE" i-minimum-length="1" --><input type="text" name="P_G_C2" size="14" value="NA"></span></u></td>
      <td valign="top" style="width: 237; height: 23; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;</span></u><b><font size="3"><!--webbot bot="Validation" S-Display-Name="University/ Board" S-Data-Type="String" B-Allow-Letters="TRUE" B-Allow-WhiteSpace="TRUE" B-Value-Required="TRUE" I-Minimum-Length="2" --><input type="text" name="University_Board2" size="27" value="NA"></font></b></td>
    </tr>
    <tr style="page-break-inside: avoid; height: 30.5pt">
      <td valign="top" style="width: 171; height: 26; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-display-name="Qualification Code" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="Qualification_code3">
      <option>Select</option>
      <option value="000">NA</option>
      <option value="002">10+2 or Equivalent</option>
      <option value="005">Graduation or Equivalent</option>
      <option value="006">Post Graduation or Equivalent</option>
      </select></span></u></td>
      <td valign="top" style="width: 181; height: 26; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-display-name="Main Subjects" s-data-type="String" b-allow-letters="TRUE" b-allow-whitespace="TRUE" s-allow-other-chars="/" b-value-required="TRUE" --><input type="text" name="Main_Subjects3" size="25" value="NA"></span></u></td>
      <td valign="top" style="width: 55; height: 26; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: center"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-data-type="String" b-allow-digits="TRUE" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="4" --><input type="text" name="Year3" size="9" maxlength="4" value="0000"></span></u></td>
      <td valign="top" style="width: 109; height: 26; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;<!--webbot bot="Validation" s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE" s-allow-other-chars="%" b-value-required="TRUE" i-minimum-length="1" --><input type="text" name="P_G_C3" size="14" value="NA"></span></u></td>
      <td valign="top" style="width: 237; height: 26; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
      <p class="MsoNormal" style="text-align: justify"><u>
      <span style="text-decoration: none; font-size: 8.0pt; font-family: Arial">
      &nbsp;</span></u><b><font size="3"><!--webbot bot="Validation" S-Display-Name="University/ Board" S-Data-Type="String" B-Allow-Letters="TRUE" B-Allow-WhiteSpace="TRUE" B-Value-Required="TRUE" I-Minimum-Length="2" --><input type="text" name="University_Board3" size="27" value="NA"></font></b></td>
    </tr>
    </table>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <font color="#000080"><b>HDN&nbsp;
  <!--webbot bot="Validation" s-display-name="HND" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1" name="HND">
  <option>select</option>
  <option>Computing</option>
  <option>Software</option>
  <option>Business Info Tech</option>
  <option>Computing & Multimedia</option>
  </select></b></font></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <span style="font-size: 8.0pt; font-family: Arial">&nbsp;</span><span style="font-family: Times New Roman"><b><font color="#000080">DD 
  Details&nbsp; (Payable to IGNOU)</font></b></span></p>
  <table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; border: medium none; margin-left: 27.9pt" height="41" width="675">
    <tr>
      <td valign="top" style="width: 155; border: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="16" align="center">
      <p class="MsoNormal" style="text-align: justify; line-height: 12.0pt"><b>
      <font size="3" color="#000080">DD No.</font></b></td>
      <td valign="top" style="width: 158; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="16" align="center">
      <p class="MsoNormal" style="text-align: justify; line-height: 12.0pt"><b>
      <font size="3" color="#000080">DD Date</font></b></td>
      <td valign="top" style="width: 151; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="16" align="center">
      <p class="MsoNormal" style="text-align: justify; line-height: 12.0pt; margin-left: -2.0pt">
      <b><font size="3" color="#000080">DD Amount(In Rs.)</font></b></td>
      <td valign="top" style="width: 151; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="16" align="center">
      <p class="MsoNormal" style="text-align: justify; line-height: 12.0pt"><b>
      <font size="3" color="#000080">Bank Name</font></b></td>
    </tr>
    <tr style="page-break-inside: avoid">
      <td valign="top" style="width: 155; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="21">
      <p class="MsoNormal" style="text-align: justify; line-height: 150%">
      <!--webbot bot="Validation" s-display-name="DD No." s-data-type="String" b-allow-digits="TRUE" b-value-required="TRUE" --><input type="text" name="DD_No" size="20"></td>
      <td valign="top" style="width: 158; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="21">
      <p class="MsoNormal" style="text-align: justify">
      <!--webbot bot="Validation" s-display-name="DD Date." s-data-type="String" b-allow-digits="TRUE" s-allow-other-chars="/" b-value-required="TRUE" i-minimum-length="10" i-maximum-length="10" --><input type="text" name="DD_Date" size="20" value="dd/mm/yyyy" maxlength="10"></td>
      <td valign="top" style="width: 151; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="21">
      <p class="MsoNormal" style="text-align: justify">
      <span style="font-size: 8.0pt; font-family: Arial">&nbsp;<!--webbot bot="Validation" s-display-name="DD Amount" s-data-type="Number" s-number-separators=",." b-value-required="TRUE" i-minimum-length="4" i-maximum-length="4" --><input type="text" name="DD_Amt" size="20" value="7500" maxlength="4"></span></td>
      <td valign="top" style="width: 151; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" height="21">
      <p class="MsoNormal" style="text-align: justify">
      <span style="font-size: 8.0pt; font-family: Arial">&nbsp;<!--webbot bot="Validation" s-data-type="String" b-allow-letters="TRUE" b-allow-whitespace="TRUE" b-value-required="TRUE" i-minimum-length="3" --><input type="text" name="Bank_Name" size="20"></span></td>
    </tr>
  </table>
  <p><!--webbot bot="ConfirmationField" S-Field="ID" --></p>
  <p>&nbsp;</p>
  <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
  <p>&nbsp;</p>
</form>

</body>

</html>

There are tidier ways to write to an Access database, that can be edited easily. See the example...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.