using Datagrid

[patb]

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

[Psyrus]

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.