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.

  1. bymbah

    bymbah New Member

    Joined:
    Dec 12, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    Hi guys;

    can anyone tell me how to overcome this asp error, i am getting upon trying to update an ms access database table.
    The error reads

    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


    Here is my asp 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
    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>
    
    
    And this is the associated 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 me out, this problem.
     

Share This Page