1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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

    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.

    !--#include file= "adovbs.asp"-->
    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.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("telephone number")=Request.Form("tel")

    Here s the html code:

    <head><title>Clients Form</title>
    <h1><u>Enter Client Details</u></h1><br/><br/>
    <form  action="" 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>
    <td><input type="submit" value="Submit" name="sbmt" >
    <input type="reset" value="clear"></td></tr>
    Please help.
  2. shabbir

    shabbir Administrator Staff Member

Thread Status:
Not open for further replies.

Share This Page