cn.Open Set rs = New ADODB.Recordset rs.CursorLocation = adUseClient rs.Open "select * from info", cn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource = rs rs.Close cn.Close