temporary table for VBA Access

[eugz]

Hi All.
In my porject I use Access form like frontend and SQL Server like backend. Question is: Is it possible use temporary table SQL Server for VBA Access if yes how to do it?
Thanks.

 

[jamesWP]

Quick translation for those who may be able to help him but may not undertsand what he's saying:

Hi all,
My project uses Access forms for the front end, It also uses SQL Server as the back end, my question is, is it possible to use temporary tables in SQL Server with VBA in access, if so, how?

 

[AndyVM]

What is the purpose of the temporary table?