1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,283
    Likes Received:
    364
    Trophy Points:
    83
Thread Status:
Not open for further replies.

Share This Page