Record set Move Next fails for MS Access DB

Experts,

I am calling a javascript function from a click event of a button (HTML). I can get the record count (which happens to be 9). The database used is MS Access. But itfails every time it gets to the "MoveNext" of the recordset. Below is the code:


Thanks for all the help!

function FetchNextData() {
      var cn;
      var rs;
      var sql;
      var conn;
      var sql; 
      var i;
	  

	  
	  i=0;
      rs = new ActiveXObject("ADODB.Recordset");
      conn = new ActiveXObject("ADODB.Connection");
      val ="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\QTPDb.accdb;Persist Security Info=False"; 	
      conn.open (val);	 
	  rs.CursorType = 3;

	  sql ="select CauseOfLoss1 from IMContEquip1";	  
	  rs.open (sql,conn);
	 //rs.open (sql,conn,1,1);
	 //alert ("Record Count  " + rs.recordcount);
	  while (!rs.EOF)
	  { 	
		//document.forms['frm'].elements[4].value = rs(i);
		alert(rs(i));
		rs.movenext();      
		i=i+1;
	  }	
	  rs.close();	 
	  conn.close (); 

}

Select allOpen in new window