Have you tried SET SAFETY OFF?
>
>I'm pretty sure that I'm asking something very simple but I couldn't find it anywhere.
>
>I'm using queries that are producing tables which I'm consulting afterwards. I installed this automatism in a form but everytime I run the query, I'm asked if I want to overwrite the existing table. Needless to say that this kind of message is not wanted in a user-friendly application. So, is there anyway to shut down this function and have the program always overwrite files when they already exist or do I have to, like I'm doing now, manually delete the existing files before running every single one of my queries?
>
>Thanks a lot, Steph.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05