I'm doing a simple excel project and part of it is updating fields in a table. Say the recordset has 500 entries. For some entries, when I update I have no issue but when I update older entries from an access database, I get the following error. "Runtime error 438 Object doesn't support this property or method". I'm using ADO connectivity and excel as a database
rs.Open "SELECT * FROM [tblfissection$] Where RequestNo = " & requestNoSubstringed, conn, adOpenStatic, adLockOptimistic, adCmdText
On Error GoTo updateFISTable
'rs.Fields(1) = ""
'rs.Fields(2) = DTEvaluationDate.Value
rs.Fields(3) = TextProposedSolOutline.Text
Any ideas