By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Web Enabled Access 2000 Database

P: n/a
Hello to all,

Having developed a Database in Access 2000, I would like to have the database input forms web accessible.

I do not know the first thing about Web-Enabled databases, be it how they work, administration, security, design or software issues.

Could someone lead me in the direction to the beginner based book or web site?

Thanks, Glen
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You have to upload the mdb to the website. From there you will have 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.

This example will work if your isp supports Microsoft ASP pages like we
do... (watch out for line wrapping in the code)

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>"
%>

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and Access

Nov 12 '05 #2

P: n/a
NB
You may want to read about "Data access page" in Access Help
Then about IIS in Windows Help

NB
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.