By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,097 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,097 IT Pros & Developers. It's quick & easy.

Rowset not bookmarkable

P: 12
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
Mar 18 '07 #1
Share this Question
Share on Google+
3 Replies


100+
P: 375
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
Mar 19 '07 #2

100+
P: 149
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
Mar 19 '07 #3

P: 12
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....
Mar 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.