I have a query that bombs out with a "there is not enough memory to complete this operation" error when run from a form (regardless of whether the data session is private or default) -- or run manually from the command window in the form's data session, even after closing all tables in that data session. If I run the query in the default data session from the command window (when no form is using the default data session), it works, even while there's a private data session active in which it *won't* work.

The tables are small, and the behavior is consistent even after a fresh boot. The query involves a left outer join.

Any ideas?