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: !--#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: 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> </td> <td><input type="submit" value="Submit" name="sbmt" > <input type="reset" value="clear"></td></tr> </table> </form> </body> </html> Please help.
