using Datagrid

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

This link addresses your problem.

http://support.microsoft.com/support.../Q278/4/08.ASP

To fix this you must replace the constant adOpenDynamic with adOpenKeyset or adOpenStatic.