Kathy,
You need file based access to the database from your Intranet server. From
there you will create two
pages, one that holds the form and fields, the second that holds the code to
connect to your mdb. Then execute an "INSERT" sql statement to get the data
into a table. If you are not familiar with any of that, you should look
into the ADO connection object. It would accomplish all of this easily if
you can use ASP or vbscript on the second page. It is important to keep in
mind that the code written on the second page runs only on the server and is
never shown to the user by means of using special tags that specify to
"runat" the server.
If you are running IIS on your intranet server then this is the vbscript for
Microsoft ASP pages...
First page: (firstpage.asp)
<html>
<body>
<p>Please fill in this data....</p>
<form name="myform" method="post" action="secondpage.asp">
<input name="fldFirstName" Value="">
<input name="fldLastName" Value="">
</form>
</body>
</html>
Second page: (secondpage.asp)
<%
dim cn
Set cnn1 = Server.CreateObject("ADODB.Connection")
cnn1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/somesubfolder/somedb.mdb") & ";Persist Security Info=False"
cnn1.execute "INSERT Into myTable FirstName, LastName VALUES(" &
request.form("fldFirstName") & ", " & request.form("fldLastName") & ")"
cnn.close
set cnn = nothing
response.write "<html><body><p>Thanks for adding that
data...</p></body></html>"
%>
You can replace the Server.MapPath() with the actual path to the mdb. The
tools are all there, it's just
a matter of learning! Let me know if you need any more help with that.
Good Luck!!
Jerry Boone
je***@antech.biz.nospam (remove .nospam before sending)
President - Analytical Technologies, Inc.
ASP, ASP.NET, SQL Server Hosting
http://www.antech.biz
"Kathy" <kd******@earthlink.net> wrote in message
news:a_*****************@newsread2.news.atl.earthl ink.net...
Can someone help me with the code to take the data in four fields on an
HTML form and add it to a table in a database on an intranet.
Thanks to all who help!
Kathy
