How to solve this asp error

bymbah's Avatar, Join Date: Dec 2006
Light Poster
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: asp
!--#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:

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.
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Duplicate of How to solve this asp error. Thread closed.