It looks like you are using ADO which appears that ".AddNew" / ".Edit" are not required. (I use only DAO)
My first thought would be to check if the recordset is open.
Add the two lines in BLUE
Set a break point at the debug line and check the SQL string to see if it is a valid SQL string.
Code:
SqlStr = "Select * From tempExportsForMerge Where LeaseId = " & lLeaseId & " And UserId = '" & TempVars("UserId") & "'"
Debug.Print SqlStr
rs.Source = SqlStr
rs.Open
MsgBox rs("DateCreated")
I also wonder if the table is normalized. 115 fields seems like a lot of fields....
BTW, looking at the reference that Paul provided, Jet 4 (DAO) allows for up to 99 fields.
My $0.02 worth...