>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?
How about posting the query?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up