I have a MS Access database named VBQUIZ.mdb. The MDB file has 3
tables which are Option, Question and Quiz.
My code in VBScript is here :
Code
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/_mysite1/VBQUIZ.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Option", conn
do until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write(" = ")
Response.Write(x.value & "<br />")
next
Response.Write("<br />")
rs.MoveNext
loop
rs.close
conn.close
What is going on, tell me please!!!
Leer las respuestas