Hello,

I am trying to insert a row into and access database embedded within a website.

I can successfully Delete and Update records, but I get an error when I try to insert. Here is the code (successful update and delete and unsuccessful insert into).

Insert Into (Unsuccessful)

var strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\T03web01\\AreaWebs\\" +
                    "Quality\\QA\\Systems\\TPD\\database\\tpd.mdb" ; //Connection String
var adoConnection = Server.CreateObject("ADODB.Connection");
var mySQL = "INSERT INTO users (user_Id, tm_Number, lname, fname, password, Access) Values ('test',12345,'testfirst','testlast','vader2',1) ";
adoConnection.Open(strConnection);
var adoRecordset = Server.CreateObject("ADODB.Recordset");
adoRecordset=adoConnection.Execute(mySQL);


Delete: (Successful)

var strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\T03web01\\AreaWebs\\" +
                    "Quality\\QA\\Systems\\TPD\\database\\tpd.mdb" ; //Connection String
var adoConnection = Server.CreateObject("ADODB.Connection");
var mySQL = "UPDATE users SET Access = 1 where user_Id = 'marajade208'";
adoConnection.Open(strConnection);
var adoRecordset = Server.CreateObject("ADODB.Recordset");
adoRecordset=adoConnection.Execute(mySQL);


Update: (Successful)

var strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\T03web01\\AreaWebs\\" +
                    "Quality\\QA\\Systems\\TPD\\database\\tpd.mdb" ; //Connection String
var adoConnection = Server.CreateObject("ADODB.Connection");
var mySQL = "DELETE from users where user_Id = 'test'";
adoConnection.Open(strConnection);
var adoRecordset = Server.CreateObject("ADODB.Recordset");
adoRecordset=adoConnection.Execute(mySQL);


Thanks for any help!!!

Also,

Can someone explain to me why this code works:
__________________________________________________ _
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
var strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\T03web01\\AreaWebs\\" +
                    "Quality\\QA\\Systems\\TPD\\database\\tpd.mdb" ; //Connection String
var adoConnection = Server.CreateObject("ADODB.Connection");
var mySQL = "INSERT INTO access_Levels ([value], [level]) VALUES (4,'qe')";
adoConnection.Open(strConnection);
var adoRecordset = Server.CreateObject("ADODB.Recordset");

adoRecordset=adoConnection.Execute(mySQL);

adoRecordset.Close();
adoRecordset = null;
adoConnection.Close();
adoConnection = null;
%>
__________________________________________________ ____________

but this code will insert the data, but still give me an error?

__________________________________________________ ________________
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
var strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\T03web01\\AreaWebs\\" +
                    "Quality\\QA\\Systems\\TPD\\database\\tpd.mdb" ; //Connection String
var adoConnection = Server.CreateObject("ADODB.Connection");
var nu_m = parseInt(4);
var lev = String("qe");
var mySQL = "INSERT INTO access_Levels ([value], [level]) VALUES ("+nu_m+",'"+lev+"')";
adoConnection.Open(strConnection);
var adoRecordset = Server.CreateObject("ADODB.Recordset");

adoRecordset=adoConnection.Execute(mySQL);

adoRecordset.Close();
adoRecordset = null;
adoConnection.Close();
adoConnection = null;
%>
__________________________________________________ _________________


Thanks

Hey,

Did you try to response.write those fields to make sure the correct values are being provided? Also, for the client code, did you ensure that tm_number is a number data type, and that the other data types are correct? No length violations, and such as well?

Brian