Hello guys, In my previous thread I forwarded the error quoted below "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" But then my buddie suggested that I alter the code as given below: and this was my line 13 : 'RS.Open "Client Details", DB, adOpenStatic, adLockPessimistic,adCmdTable 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.source = "Client Details" RS.activeconnection = objconn RS.CursorType = 2 RS.LockType = 3 RS.open 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> But now I am getting this error: ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /Add_Client_Details.asp, line 15 Can anyone suggest for me, how to overcome such an error. Thanx in advance.
