Just a note: I made a minor change to my workspace and in preferences. After saving, I now find that all recordset dialogs open in "Advanced" and cannot go to "Simple" without receiving this notice: "The simple Recordset dialog box cannot be opened because the SQL is too complex." This happens no matter what. If I create a new recordset, it opens in "Advanced" and won't go to "Simple."
I did try removing the cache file and restarting.
I can live with this if there is no solution, but there is sometimes some convenience in using the simple interface.