>Is there any way to stop the program from asking if you want rewrite a table that is tied to a query? I have reports that are generated on information from my main tables, I run the query based on the main tables then run the reports based on the query tables. I have tried set safety off. Is there another command that I need to use?

SAFETY OFF should work fine. It's scoped by datasession, though, so that could be your problem. Also, in another direction, you could use cursors for reports, that's a standard way to do it...