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

ms access web how-to

P: n/a
Hello.

I am hoping to get some help here about connecting, directly or not,
an Access database with a web site. I have done some research but have
not come up with much of use.

I am wondering what would be the best the way to collect information
from a web form and put this information into an Access database? Just
brain storming I have come up with a few ideas (but I do not know how
to go about getting the job done):

- having the data be sent directly to the Access database.
- having the data be send to a berkeley or mysql database and then
transferring.
- having the data be sent by email to outlook, and from there connect
it to Access.

Can you please help me figure out which is the best way to get this
done and if possible provide me with some information/guidelines as to
what I should do?

[The server where the form will be located is hosted on a remote
server, not the computer with the Access db].

Cheers...
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Mora,

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...

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

Then you could periodically download the table and copy/paste the contents.
If you get even more crafty with ASP and ADO, you could start having it
email you an ADO recordset (or xml file) that you could open with an access
form and import using some custom code. 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
"mora" <mo******@hotmail.com> wrote in message
news:4f**************************@posting.google.c om...
Hello.

I am hoping to get some help here about connecting, directly or not,
an Access database with a web site. I have done some research but have
not come up with much of use.

I am wondering what would be the best the way to collect information
from a web form and put this information into an Access database? Just
brain storming I have come up with a few ideas (but I do not know how
to go about getting the job done):

- having the data be sent directly to the Access database.
- having the data be send to a berkeley or mysql database and then
transferring.
- having the data be sent by email to outlook, and from there connect
it to Access.

Can you please help me figure out which is the best way to get this
done and if possible provide me with some information/guidelines as to
what I should do?

[The server where the form will be located is hosted on a remote
server, not the computer with the Access db].

Cheers...

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.