How to base a query & report on a temporary table?

[NCYankee1]

In Access XP I have a report that first fires off a group of queries to do a bunch of stuff and place their results into a work table (after deleting the contents of this work table). The report than reads this table and produces the output.

The problem is when multiple users try to run this report at the same time everyone but the first person in will fail because the work table is locked.

I'd like to be able to create a varibale-named "temp" table to base my report on so that people aren't locking each other out. How do I point the report and queries at a table whose name is variable?

 

[ajdesalvo]

I would suggest creating a front end/back end setup of your database.

Place all of your shared data tables into one shared database (placed on a shred directory on a file server), leaving the temp tables in the front-end database. Link all the tables in your front end database.

Then each workstation would have it's own temp table, and your locking issue would disappear. Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"