G Guest Jul 30, 2006 #1 how Connect an HTML form to Access Database? what is the ASP code for connecting it???
A Arvin Meyer [MVP] Jul 31, 2006 #2 human_bein said: how Connect an HTML form to Access Database? what is the ASP code for connecting it??? Click to expand... 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
human_bein said: how Connect an HTML form to Access Database? what is the ASP code for connecting it??? Click to expand... 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