>I am creating a program in which I create tables to preview reports. I delete the temporary tables after the report is done being viewed/printed. The program is a multi-user program and if it so happens that User A is previewing the report and User B wants to view the same report they would get an error because it tries to create a table with the same name.

your 3rd and better option is not to create a table; but to create a cursor.

crea cursor (blah)
and use it like a table...

it's temporary; so when you close it; foxpro automatically deletes the files assoiciated with (dbf, fpt, cdx)