Temp Tables

[ericchajmovic]

Hello,

I have MS Access as a front-end. Where is the proper place to create temp tables?

Thanks,

Eric Chajmovic

 

[tlbroadbent]

It depends on whether the code is being run on SQL Server or the client PC. If the data is in SQL Server, I recommend using SQL Server stored procedures and creating temp tables in SQL Server, then returning data to the Access front end. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.