Current recordset does not support updating Mopile sex chat video no imell
I use a variable just to make it easier to change if i want to use this sub somewhere else.
I'm using SQL Server 2000, and I'm having a slight problem with a recordset from a stored procedure.
Jan 09, 2013 Hi Dale Roedger, I would try various combinations of the cursortype and locktype, I expect the cursortype is the one to start out with.
I'm no expert on this, but AFAIK, the keyset one is used mostly when using SQL Server Since you use an Access database I'd start with trying ad Open Dynamic.
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... Command Text = "Select PODate, POLoc, POItem FROM Pur Ord " & _ "where PODate = #" & Selected Date & "# and POLoc = '" & str Loc & "' " & _ "AND POItem = " & CInt(str Item) POrst Data = C.