Current recordset does not support updating ado

Record Set And Check "str Archive Path" Should have last Char ="\" some thing like : C:\My Folder\Data\ Regards Veena I still get the same error...

You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

set") rs.cursor Type = ad Open Keyset (or ad Open Dynamic) rs.

How do you get VBScript to update its record set back to the SQL server?

Here is the test code I have, but I get this error Line: 18 Char: 1 Error: Current Recordset does not support updating. a returned Recordset object is always a read-only, forward-only cursor.

I'm using SQL Server 2000, and I'm having a slight problem with a recordset from a stored procedure.

When the query is first opened all settings indicate that the recordset is editable.

This may be limation of the provider, or of the selected locktype. Recordset Dim strmess As String Set cnp = Current Project.

Connection strmess = "SELECT * from tblinvoicelines WHERE invoice=" & new Invo Set red1 = cnp.

I added the above Cursor Location to see if problem went away, but it didn't. Michael Lee I have changed the above slightly but I'm getting the same results. Bob Just remove the space between faq and 222 - like this FAQ222-3670 ________________________________________________________________If you want to get the best response to a question, please check out FAQ222-2244 first'If we're supposed to work in Hex, why have we only got A fingers?

Execute Here is the Stored procedure: CREATE PROCEDURE [dbo].[nb_Get Insurance]@Patient ID nvarchar(12),@Admission Date smalldatetime ASSelect Key Id, Patient ID, Admission Date, Insurance_Name, Insurance_Number From Insurance Where Patient Id = @Patient Id and Admission Date = @Admission Date GOI do have the Cursor Location set for the connection object. (Read up on "disconnected recordsets" if you're interested.) I did an faq called "nickel tour of ado's different cursor types" (faq 222-3670, sorry, I haven't learned how to plug the hyperlink in here) if you're interested.

I don't think that method will work if you want to update your recordset.