Form online to add MDB data entries?

[tyleri]

I'm having the damndest time trying to figure out how to get a form online to send data into an Access table already running on my server.

Right now I have to resort to opening the Access file, then filling in the info into the table, and then uploading the 300kb file to my server.

Does any one have examples or a website that will give me step by step instructions on how to do this?

PS - I am also going to eventually need to know how to create an EDIT form online as well.

Thanks a lot!

 

[ehsant]

Hi ...
you have so much work to do.
you can read the older posts.
but for a brief:
you can have two ASP files.
ASP 1, your form :

firstasp.asp

<form name=&quot;myform&quot; action=&quot;secondasp.asp&quot; method=&quot;post&quot;>
<input type=&quot;text&quot; name=&quot;myinput&quot;>
</form>

ASP 2, the DB part:
secondasp.asp

<%
Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot
strDBcnn = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myDB.mdb;Persist Security Info=False&quot;

objConn.Open strDBcnn

Set objRS = Server.CreateObject(&quot;ADODB.RecordSet&quot
objRS.Open &quot;MyTable&quot;, objConn, 3, 3
objRS.AddNew ()

objRS(&quot;MyField&quot = Request.Form(&quot;myinput&quot

objRS.Update()
objRS.Close()
Set objRS = Nothing
objConn.Close()
Set objConn = Nothing

Response.Redirec &quot;Someotherasp.asp&quot;
%>

this was a simple sample.
you can expand it as your need.
----
TNX.
E.T.

 

[onpnt]

faq333-2120 I dare to learn more

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com