locking problems

[knothed]

I run a macro that copies a table and runs a query and opens a report both on this temporary table. In the on close event of the report I would like to delete this temporary table but access tells me it can not lock the table because it is in use by someone else. I am currently the only user of this table. Any ideas where the error in my thinking occurs?

Thanks in advance

 

[knothed]

Thanks Pat for you help but perhaps I didn't explain my problem very well. In our multiuser enviroment if any user has one of the many forms linked to this table open the query approach does not work because the table can not be locked. That's why I decided to do the temp table arrangment and I need the print preview option because all these reports have running sums in the footers which users need to be able to see...any other ideas?
Thanks again

 

[Richie]

Why don't you put the running sum on a form and let users see that?