connectivity of Javascript to Ms-Access

[Ranu Garg]

i m having problem in this code (when i m using connectivity between javascript to Ms-access)error is on cn.Open(strConn );
plz help me its urgent..

var cn = new ActiveXObject("ADODB.Connection")
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='D:\circus\feedback.mdb'"
var rs = new ActiveXObject("ADODB.Recordset")
var SQL = "INSERT INTO Customers(FirstName, Surname)" + " VALUES ( '"+ names.value +"', '" + surname.value +"')"


cn.Open(strConn)
rs.Open(SQL, cn) 


alert("database saved")

[Rabbit]

I don't see the error text.

[C CSR]

Am I wrong or did you forget the closing " on the var strConn line?

[Monty sing]

I think your Connection is already open and you are trying to reopen it that's cause the error is showing

use code to check the state of database whether is open or closed