I want to make a .ASP site where i can test *ANY* SQL statement towards an MDB (.mdb database)

So far i've made a new empty DB called: skriv.mdb
then i try to use the following code to send SQL commands to the DB

But my problem is that any results from the DB is not displayed back to me..
So if i do a: SELECT * FROM sometable; then i wont get the output back to me, so i need help to archeive this,..

Simply make an .ASP that can perform ANY sql-statement towards an DB..

So far i have this, which writes to the DB, but doesnt always work correctly
(It has problems opening/closing the connection, and NO errortrapping)

Please try to put together a working example..Thanks anyway !!
VB Code:
  1. <HTML>

  2. <BODY>

  3. <center>

  4. <B>SQL Query Testing</B><br><br>

  5. EXAMPLES:<br>

  6. create table tabell1 (data1 char(100),data2 char(100)); <br>

  7. insert into tabell1 (data1,data2) values ('tekst1','tekst2'); <br>

  8. select data1,data2 from tabell1; <br>

  9. select * from tabell1; <br>

  10. <br><br>

  11.  
  12.  
  13.   <font color="red">Skriv til database:</font>

  14.   <FORM METHOD="post" ACTION="skriv.asp?Actionvar=sql">

  15.   SQL: <INPUT TYPE="text" NAME="sql1"><BR>

  16.   <INPUT TYPE="hidden" NAME="flag" VALUE="2">

  17.   <INPUT TYPE="submit" VALUE="Utfør SQL">

  18.   </FORM>

  19.  
  20. <%

  21. Actionvar=Request.QueryString("actionvar") '''gets the ActionVariable..

  22.  
  23. '''Setup the connection to the database

  24.  Set conn = server.createobject("adodb.connection")

  25.  DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "

  26.  DSNtemp=dsntemp & "DBQ=" & server.mappath("skriv.mdb")

  27.  conn.Open DSNtemp

  28.  

  29. '''Check the querystring to decide what to do next, getting the flag..

  30. IF Actionvar="sql" THEN

  31. IF Len(TRIM(request.form("flag"))) = 0 THEN

  32. %>

  33.  
  34.  
  35. <%

  36. '''if flag was set, means that a search string has been inputted, and its time to search the DB..

  37. ELSEIF Request.Form("flag")="2" THEN

  38. SQLstmt = SQLstmt & request.form("sql1")

  39. %>

  40.  
  41.  
  42. <%

  43. '''Run the SQL statement at the DB, to perform the search..

  44. conn.execute(SQLstmt)

  45. Response.Write SQLstmt '''debugging.. to see what we runned at the DB..

  46.  
  47.  
  48. END IF

  49. end if

  50.  
  51. '''Close the DB connection..

  52. conn.Close

  53. Set conn = nothing

  54. Set SQLstmt = nothing

  55. %>

  56.  
  57. <!-- need code here to show the search results -->

  58.  
  59. </BODY>

  60. </HTML>