Hello,
i made one form in flash using acces and asp.
the value put in text field are properly goes in to the database (in mdb file)
now i want to show that records in another asp page.
how i will gate it.
here is the code…
<%
Mypath = Request.ServerVariables(“APPL_PHYSICAL_PATH”)
MyPath= Mypath & “form\example.mdb”
sConStr=(“driver={Microsoft Access Driver (*.mdb)}; dbq=” & Mypath)
Provider=“Microsoft.Jet.OLEDB.4.0;Data Source=” & Mypath & “;Persist Security Info=False”
set conn= server.CreateObject(“adodb.connection”)
conn.Provider = Provider
conn.CursorLocation = 3
conn.Open path, “admin”, “”
strFirst = Request.Form(“fname”)
strLast = Request.Form(“lname”)
strEmail = Request.Form(“email”)
strMessage = Request.Form(“message”)
‘Response.End
strSQL = "INSERT INTO contacts (FirstName,LastName,Email,Message)VALUES (’" & strFirst & “’,’” & strLast & “’,’” & strEmail & “’,’” & strMessage & “’)”
strFirst & “’,’” & strLast & “’,’” & strEmail & “’,’” & strMessage & “’)”
conn.Execute strSQL
%>
