Hello, I am very new to ASP and i am trying to learn how to take data from a HTML form and enter it into a Microsoft access database. This is what i have so far, but it is not working at all!!! HELP!

<%
       'Open DSNless connection to the banner database
        dbName = "/fpdb/magic_database.mdb"
        ObjConn= "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & Server.MapPath(dbName)

       'Used when the submit button is pressed
        strcard_name = Request.Form("card_name")
        strcard_set = Request.Form("card_set")
        strcard_color = Request.Form("card_color")
        strquantity = Request.Form("quantity")
        Recordset.Open "magic_entry", strConn, adOpenDynamic, adLockOptimistic, adCmdTableDirect
        .AddNew
          .Fields("card_name") = strcard_name
          .Fields("card_set") = strcard_set
          .Fields("card_color") = strcard_color
          .Fields("quantity") = strquantity
        .update

        End
%>

<Form name="magic_entry">
<form method="POST" action="mailing_edit40894272720.asp">
<table border="0" cellpadding="2" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600" id="AutoNumber1">
  <tr>
    <td width="284" colspan="2">Card Name:
    <input type="text" name="card_name" size="26"></td>
  </tr>
  <tr>
    <td width="284" colspan="2">Card Set: <select size="1" name="card_set">
    <option value="darksteal">Darksteal</option>
    <option value="mirrodin">Mirrodin</option>
    <option value="8th">8th Edition</option>
    </select></td>
  </tr>
  <tr>
    <td width="284" colspan="2">Color: <select size="1" name="card_color">
    <option>White</option>
    <option>Blue</option>
    <option>Black</option>
    <option>Green</option>
    <option>Multicolor</option>
    <option>Artifact</option>
    <option>Land</option>
    <option>Red</option>
    </select></td>
  </tr>
  <tr>
    <td width="142">Quantity: <input type="text" name="quantity" size="5"></td>
    <td width="142"><input type="submit" value="Submit" name="B1">&nbsp;
    <input type="reset" value="Reset" name="B2"></td>
  </tr>
</table>

Please tell me what i did wrong, and it would be great to know as fast as i can. Because i have to have this done for my boss by friday! (YIKES)

Hi there,

What error do you get?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

hello

  shldnt it be ObjConn instead of strConn??

500 internal server error

Please follow the instructions in this FAQ to get more detailed error information, and then post the outcome of the detailed error message to this forum.

Didn't the solution suggested by dhaywirex fix the problem?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.