I am trying to run an Access macro, in which one of the functionalities is that tables are deleted and made automatically. I want to have it so the warning message that says "The existing table xxxx will be deleted before you run the query" doesn't appear. From what I read, I need to use DoCmd.SetWarnings False in my code. However, this only seems to work if I first run it through the Visual Basic editor open in Access. If I close it and run the macro, I get the warning message again. Does anyone know why this happens? Thanks.