recordsets

Hi All, I'm working on a VBA app written by a much more capable colleague and he isn't in today, without being condescending (please), could someone hazard a guess at what the following code is trying to do: If rs3(rs2(dataItem).Value) = rs2(dataValue) Or (IsNull(rs3(rs2(dataItem).Value)) And...

Hi everyone, I don't use ADO much but I've inherited something that is using ADO and I've had a few problems. Our network infrastructure isn't the greatest here and some times the connection to our shared drives momentarily drops. It doesn't unmap the drives or anything but we get an error in...

Hey ho I'm trying to move part of an Oracle table-view into a new Access(2010) table. I tried linking the table with an ODBC connection from Access - but the Oracle table is both too large for Access to handle, and Access also ended up jamming the server and p*****g off the Oracle DBAs. I...

I am not able to get values into a recordset. The first sql command to insert the records work, but when i try to retrieve the Max(ID), the recordset is Empty. Dim rst2 As DAO.Recordset Set Connection2 = CreateObject("ADODB.Connection") sServer = "SAS01SRVSQ01\SASDATA"...

Hello I've followed the MSN brief on my problem as best I can, but still have issues! I understand why it does it and why it happens, but can't seem to set my RecordSet and preserve optimistic locktype and dynamic cursor. If I understood it (probably not) correctly, I need to Open the...

'Ello Have some recordsets. Nice. A master doc connects to some csv's with the oledb text connection, dumps them all to a sheet, and simultaneously builds a 'master' recordset to do some hard crunching. Part of this is a userform that allows you to pick Fields, Operators and Values from...