Hello
I have an application in vb6 that works on MSAccess 2003. And now I have to change connection to SQL Server 2005. I changed connection string to:
conn.Open "Driver={SQL Server}; Server=server; Database=Base; UID=ID; PWD=pwd"

I open recorset like this
Set rs = cnServer.Execute("SELECT * FROM tbl")
and it is OK.
But if I try to find record in recordset using
rs.find "ID = " & textbox.text I got error msg like
"Rowset does not support scrolling backward."

There is problem wit locking, aren't it?
HELP

Recommended Answers

All 3 Replies

Yes, it sounds like an adforwardonly flag was set since you did not set them when you opened the rs.

Good Luck

vb5prgmr is correct in saying that adForwardOnly is probably your problem. Use

rs.MoveFirst

and then call your

rs.Find '.....

Tx guys

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.