How to solve this asp error

Discussion in 'ASP' started by bymbah, Apr 11, 2008.

Thread Status:
Not open for further replies.
  1. bymbah

    bymbah New Member

    Joined:
    Dec 12, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    Hi guys can anyone help me out with this asp error I'm getting upon adding information to my database table.

    Error Type:
    Microsoft JET Database Engine (0x80040E37)
    The Microsoft Jet database engine cannot find the input table or query 'Client'. Make sure it exists and that its name is spelled correctly.
    /Add_Client_Details.asp, line 13


    Can anyone tell me whats wrong with line 13 of this code.


    Code:
    
    !--#include file= "adovbs.asp"-->
    <html><head><title>Add_Client_Details</title>
    </head>
    <body>
    <%
    Dim DB
    Set DB = Server.CreateObject ("ADODB.Connection")
    DB.Mode = adModeReadWrite
    DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + "C:\Inetpub\wwwroot\Marketing Database.mdb")
    Dim RS
    Set RS = Server.CreateObject ("ADODB.Recordset")
    RS.Open "Client Details", DB, adOpenStatic, adLockPessimistic,adCmdTable 'LINE #13
    RS.AddNew
    	RS.field("Company") =Request.Form("Cmnpny")
    	RS.field("Contact Name") =Request.Form("CnctName")
    	RS.field("Designation") =Request.Form("Dsgn")
    	RS.field("Address") =Request.Form("Cmpny")
    	RS.field("e-mail")=Request.Form("email")
    	RS.field("telephone number")=Request.Form("tel")
    RS.Update
    %>
    </body>
    </html>
    
    

    Here s the html code:

    HTML:
    
    <html>
    <head><title>Clients Form</title>
    </head>
    <body>
    <h1><u>Enter Client Details</u></h1><br/><br/>
    <form  action="http://127.0.0.1/Add_Client_Details.asp" method="post">
    <table border="0">
    <tr><td align="right">Company:</td>
    <td align="left"> <input type="text" name="Cmpny" size="30"></td></tr>
    <tr><td align="right">Contact Name:</td> 
    <td align="left"><input type="text" name="CnctName" size="30"></td></tr>>
    <tr><td align="right">Designation:</td>
    <td align="left"> <input type="text" name="Dsgn" size="30"></td></tr>
    <tr><td align="right">Company Address:</td>
    <td align="left"><input type="text" name="CmpnyAdd" size="30"></td></tr>
    <tr><td align="right">E-mail:</td>
    <td align="left"><input type="text" name="email" size="30"></td></tr>
    <tr><td align="right">Telephone:</td>
    <td align="left"><input type="text" name="tel" size="30"></td></tr>
    <tr><td>&nbsp;</td>
    <td><input type="submit" value="Submit" name="sbmt" >
    <input type="reset" value="clear"></td></tr>
    </table>
    </form>
    
    </body>
    </html>
    
    
    
    Please help.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice