I am trying to display a table in a datagrid. I have written the necessary codes to open the database and also the recordset.
I have set the datasource of the datagrid to the recordset but when I run it, I receive an error message telling me 'The Rowset is not bookmarkable'

Dim Tble As ADODB.Recordset

Set Tble = New ADODB.Recordset

Tble.Open "temp", adodbConnection, adOpenDynamic, adLockOptimistic

Set Data1.DataSource = Tble

if there is any errors, please indicate them to me or else give me the codes that are required to connect my table to the datagrid

thanks