I linked an Outlook (exchange) folder as a table in an access 2010 database. With VBA code I read this table, I perform some actions and then I finally change the field "Normalized Subject" of each processed record by adding text behind the extisting title. In OUTLOOK, after running my VBA code the Subject titles have changed as I want. However: This was before upgrading from XP to Windows 7. But after upgrading to Windows 7, my VBA code can not longer change the mail subject title anymore. Also I can not change the subject field "Nomralized Subject" manually direct in the table anymore.
I get an error "No current record" as shown below.
Set rst=db.openrecordset("Select * from OUTLOOK_FOLDER")
With rst
.movefirst
Do until .EOF
Title=rst("Normalized Subject")
.......
.......
.Edit
rst("Normalized Subject")=Title + " Processed"
.Update
debug.print rst("Normalized Subject") THE CODE STOPS AT THIS STATEMENT WITH ERROR: "NO CURRENT RECORD"
.MoveNext
End with
Note: if I enter text in a record in the field "Normalized Subject" behind the existing title text manually in the linked outlook folder table directly, the field does not record the change and if I click again in the field then I get the message "no current record". The record however thereafter (luckily) still exists.