How to create a temporary table in access using a query

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

Hi everyone,

I have a multi-user access db which has some linked tables to a SQL Server
and by running some VBA code, I'm trying to get some data from multiple
tables and put it into a temp file which will then be used to create and
display a report.

What the user basically does is that he/she enters dates into a form and
then the query runs, gathers the data from those muliple tables and puts out
a report. After the user closes the form or exits Access, I want this temp
table to be gone, so if the user runs the application once again, then the
same query has to be run again. I was thinking of having some fixed table so
any user who runs the application would fill it up with their query results,
but then there's the problem of two users running the application at the
same time, which would produce an inaccurate report.

So my question is, how would you handle multiple temporary tables being
created by multiple users in Access? Can I create temp tables in Access?

Thanks to all the contributors.

Al
 
Al

If you have a query written that returns the information you need for your
report, why are you adding in the step of creating a temporary table?
Access reports can be based directly on queries, too.

More info, please...

Jeff Boyce
<Access MVP>
 
Back
Top