Rowset not bookmarkable

[bahog]

Hi! can anyone tell me what should i do about this error."error 7004 Rowset not bookmarkable". I get this error when i try to set the datasource of a datagrid to recordset i created.
Code:

rs.Open "table", connection
Set Datagrid.DataSource = rs

[cmrhema]

Hi! can anyone tell me what should i do about this error."error 7004 Rowset not bookmarkable". I get this error when i try to set the datasource of a datagrid to recordset i created.
Code:

rs.Open "table", connection
Set Datagrid.DataSource = rs

Before setting the datagrid to datasource you should specify the cursor location.
1. rs.CursorLocation=adUseClient
put down the above code before you open the recordset
thereafter while opening the table also delcare the CursorType and Lock type
2. rs.Open "select * from table",connection, adOpenDynamic, adLockOptimistic
lastly set the datasource to the data grid
3. Set Datagrid.DataSource = rs

So, your code must be in the order 1,2,3

Check out and let me know whether it worked or not.
Good Luck

[ansumansahu]

Hi! can anyone tell me what should i do about this error."error 7004 Rowset not bookmarkable". I get this error when i try to set the datasource of a datagrid to recordset i created.
Code:

rs.Open "table", connection
Set Datagrid.DataSource = rs

Hi ,

I think you are using ADO. If so please check the cursor location properties.

thanks
ansuman

[bahog]

Before setting the datagrid to datasource you should specify the cursor location.
1. rs.CursorLocation=adUseClient
put down the above code before you open the recordset
thereafter while opening the table also delcare the CursorType and Lock type
2. rs.Open "select * from table",connection, adOpenDynamic, adLockOptimistic
lastly set the datasource to the data grid
3. Set Datagrid.DataSource = rs

So, your code must be in the order 1,2,3

Check out and let me know whether it worked or not.
Good Luck

I tried it and it works.... Thanks....