"Record is Deleted" response to a select query

[joeller]

I was a long time user of MS Access 97 - 2003. Since then I've been working primarily in SQL Server, Oracle, DB2 etc. So I was not familar with the new interface employed by Access 2010. However, I thought I had the basics right.

I created the query below in the query designer's SQL pane. But each time I ran it I got a message box reporting "Record is Deleted". I checked and the button showing "select" as the type of query was highlighted. So I switched to the design view pane. It rendered fine. I ran it again. Again it reported "Record is Deleted". What's going on? Has anyone else seen this behavior?

 SELECT Max(Len(Description)) AS Expr1
FROM DRActionItems;

Edward

[June7]

Never seen and can't replicate issue. If you want to provide database for analysis, follow instructions at bottom of my post. Will look at this weekend.

[joeller]

Never seen and can't replicate issue. If you want to provide database for analysis, follow instructions at bottom of my post. Will look at this weekend.

Sorry Data is FOUO. Not releasable.

[June7]

Probably don't need real data for purposes of analyzing this issue. Dummy records should serve.