As far as I can recall, Microsoft Access does not support temporary tables, or at least, does not expose them to SQL. I could be mistaken on this, and in saying this I am thinking specifically of the (now, old ...) JET Engine. Check this in the documentation first. (And if I am wrong, please make a note of that here.)