-
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.