Sending Information to a Database

Hi All,

I have created a Microsoft Access Database on my PC and also have an online form on my site. I want this information to be sent directly to my database when a person hits the submit button on my page. I have nothing launched yet on the network but it's just temporarily on my pc.

How would I set this up. I have all the fields in the database set up in 1 table and matching the fields in the form.

Would anyone have code for this.

I would be very grateful if someone could help me out.

Cheers

I can help you to write the code in ASP. U have to post the column names.



Thanks,

Ashi

http://www.ringvirginia.com

Hi ya,

I have IIS on my machine so hopefully you're code would work.



The name of my text fields are:

patientName

patientEmail

patientDOB

patientTelNo

patient_entry_date



The names of the fields in the Database are:

Patient_Name

Email_Address

DateOfBirthTelephone_Number

DateOfEntry



Thanks very much for helping me out

Alan

<form name="form1" method="post" action="form2.asp">

<p><strong><font size="4" face="Verdana, Arial, Helvetica, sans-serif">Form: </font></strong></p>

<p>

<input name="patientName" type="text" id="patientName">

</p>

<p>

<input name="patientEmail" type="text" id="patientEmail">

</p>

<p>

<input name="patientDOB" type="text" id="patientDOB">

</p>

<p>

<input name="patientTelNo" type="text" id="patientTelNo">

</p>

<p>

<input name="patient_entry_date" type="text" id="patient_entry_date">

</p>

<p>

<input type="submit" name="Submit" value="Submit">

</p>

</form>

------------------------------------------------------------------------------

save the above form as form1.asp



Thanks,

Ashi

http://www.ringvirginia.com

<%



patientName=request.form("patientName")

response.write patientName

patientEmail=request.form("patientEmail")

response.write patientEmail

patientDOB=request.form("patientDOB")

response.write patientDOB

patientTelNo=request.form("patientTelNo")

response.write patientTelNo

patient_entry_date=request.form("patient_entry_date")

response.write patient_entry_date

'response.End



Set cnn = Server.CreateObject("ADODB.Connection")

strConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("mdbname.mdb") & ";

cnn.Open strConn

Set rs = Server.CreateObject("ADODB.Recordset")

'rs.open "select * from sform",cnn

cnn.execute "Insert INTO sform(Patient_Name,Email_Address,DateOfBirth,Telep hone_Number,DateOfEntry)values('"&patientName&"','"&patientEmail&"','"&patientDOB&"','"&patientTelNo&"','"&patient_entry_date&"')"



%>



Thanks,

Ashi

http://www.ringvirginia.com