I was writing embedded SQL in Access97 years ago, came up against a bug where a function would work only once per session. Went online, asked wtf? Never got any answers. What I did get, sporadically, for the next ten years were emails asking "did you ever find a solution...?"