Go4Expert

Go4Expert (http://www.go4expert.com/)
-   ASP (http://www.go4expert.com/forums/asp/)
-   -   How to solve this asp error (http://www.go4expert.com/forums/solve-asp-error-t9954/)

bymbah 11Apr2008 20:14

How to solve this asp error
 
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: 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
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:

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.


All times are GMT +5.5. The time now is 14:08.