Binding a datagrid to a recordset

roykennedy · October 11th, 2003, 06:37 PM

I have the following code in my application.

Code:

Dim cnOrganize As Connection
Dim rsFile As Recordset

Set cnOrganize = New Connection
cnOrganize.Open [Connection String]

Set rsFile = New Recordset
rsFile.Open "Files", cnOrganize, adOpenForwardOnly, adLockOptimistic

Set DataGrid1.DataSource = rsFile

rsFile.close
set rsFile = nothing

cnOrganize.close
set cnOrganize = nothing

When it gets to the line setting the datasource for the datagrid I get the following error.

'7004' The rowset is not bookmarkable

Is there a way that I can bind the datagrid to the recordset?

sal · October 11th, 2003, 09:10 PM

I believe that you can not bind a adOpenForwardOnly recordset to a datagrid. Try using adOpenDynamic.

Sal

roykennedy · October 11th, 2003, 10:16 PM

I tried changing it to adOpenDynamic with no luck. Thanks for the response.

After reading your reply I tried other settings and adOpenKeyset worked. Thanks, I never would have thought of changing that.

chiefouko · October 16th, 2003, 12:31 AM

Just set rstFile u need to change the cursor location to the client object. Meaning try something like this i hope this helpful.

Set rsFile = New Recordset
rstFile.cursorLocation = = adUseClient
rsFile.Open "Files", cnOrganize, adOpenForwardOnly, adLockOptimistic

Hope it's not too late!!

LION OF JUDDAH!

j2associates · October 28th, 2005, 02:15 PM

Thanks chiefouko! I would never have thought to change that setting and it worked the first time afterwards.