The rowset is not bookmarkable

Visual Basic : (Solution) Set conn = CreateObject(“ADODB.Connection”) conn.CursorLocation = adUseClient strCONN = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & App.Path & “\dbDSS.mdb;Persist Security Info=False” conn.Open strCONN, “”, “” strSQL = “SELECT * FROM ranking order by nilai DESC” Set rs = CreateObject(“ADODB.recordset”) Set rs = conn.Execute(strSQL) Set DataGrid1.DataSource = rs ‘Set rs = Nothing ‘conn.Close ‘Set conn =… [Read more…]