jeudi 19 juin 2014

How to INSERT sql to MS ACCESS using JS on IE ?


Vote count:

0




I am using IE8. I need to insert values into a table in MS access using JavaScript


I tried



var adOpenForwardOnly = 0;
var adLockReadOnly = 1;
var conn = new ActiveXObject("ADODB.Connection");
conn.open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Users\\xxx\\Database1.mdb; Persist Security Info=False");
var sql = "INSER INTO table1 VALUES(" +
var1+ ',' +
var2+ ")";
conn.open(sql) ;


But this does not recognize open method. I also triedexecute,executeSql`


What can I do with IE8 How can I make my code work ?



asked 40 secs ago

Buras

576





Aucun commentaire:

Enregistrer un commentaire