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"-->
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:

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