G
Guest
how Connect an HTML form to Access Database?
what is the ASP code for connecting it???
what is the ASP code for connecting it???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer [MVP]
human_bein said:how Connect an HTML form to Access Database?
what is the ASP code for connecting it???
One way is to create a DSN on the server and name it. The asp code would
then look something like:
<%
Dim oConn
Dim rst
set oConn = server.CreateObject("ADODB.Connection")
oConn.ConnectionString = "DSN=yourDSNname"
oConn.Open
strSQL = "SELECT * FROM tblTourTable"
set rst = oConn.Execute(strSQL)
%>
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access