Turning off erase table messages in vb 1

[Xzibit7]

I have a make table query that keeps giving me the mesaage that my table will be deleted evertime I use it. The problem is I have already gone in and turned off action messages in the options tab under tools. Is there a way to do this with vb?

 

[fdcusa]

In the example below, warning messages are turned off before the statement to delete a table, then back on after it is deleted. Hope this helps!

    DoCmd.SetWarnings False
    strSQL = "DELETE * FROM " & tdfName & ";"
    DoCmd.RunSQL strSQL
    DoCmd.SetWarnings True

 

[Xzibit7]

thanks