A new bug has surfaced impacting Microsoft Access Web Applications (AWAs) in which queries only return the first 50-60 records. This is has been confirmed by multiple sources now.

The good news, well sort of, is that fellow MVP George Hepworth found a simple workaround to the problem which is to simply apply a sort. Once you get the query results, apply a ascending or descending sort and all the records show. I know it’s not ideal, but for now, it will have to do until Microsoft fixes whatever it is that they’ve broken.

The original MSDN thread can be found at Access web app queries now being throttled to first 50 records only?