Avoiding message

Is there any way to avoid the message i get when i run a table create query?. The point is that if i run this kind of queries and the table it creates already exists, then i get a message asking if i want to overwrite that table so i have to click yes in order to continue the process. I want the table to be overwritten without asking me because when i have several queries it is a lot of time clicking "yes" and it's needed to be there to perform those clicks. please give some clue.

thanks.

You can use the SetWarnings action to disable and enable system warnings. This can be done via Macro or VB code. Check out "SetWarnings" in the help file.

well, i've already tried that and solve the problem for most of the messages but not with the one showed when a table is to be overwritten by a create table query, i don't know but maybe it is possible by code, please help

thanks

I have just set up a sample database to test this and don't have any problems. Perhaps you could post a sample of your code.

well, the thing is that when i do that in table create or overwrite messages, Access performs the predetermined option wich as i remember is "CANCEL" or something like that, so it doesn´t overwrite the table as i need. Let me know if this is true and the way to solve my issue. Just sumarizing, i need to avoid the message that appears when i run a table create query and the table it creates, it's already there, so i need to overwrite it without having to click "OK".

thanks a lot for your help

Here is a sample database which runs OK on my WinXP system. It is in Access97.

thank you very much, your example is a good idea on how to do what i need, i tried the same but from a "macro" not from a form. I´ll use your way.

thanks again.