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"-->
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.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")

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

All times are GMT +5.5. The time now is 21:48.