Temporary tables for reporting .

[Caro]

I need to create tables for reporting from Crystal. they need to be temporary and not over-writable by other network users. Can anyone tell me the best way to do this?

[Michael]

Try creating a table name based on a random number. Use an ON ERROR when you try to create it. If you get an error because the name already exists (unlikely!) then loop round and try again with a new name. Hope this helps.