DoCmd.run(strSQL) vs. CurrentDb.Execute (strSQL)

[Willem!]

Hi!

I have a tiny question which I am insecure about. I want to replace the following code: (the code makes a certain table empty)

DoCmd.SetWarnings False
strSQL = "DELETE FROM TestTable"
DoCmd.RunSQL (strSQL)
DoCmd.SetWarnings True

by the following code:

strSQL = "DELETE FROM TestTable"
CurrentDb.Execute (strSQL)

So, in other words, can I safely leave out the SetWarnings bit in the newer code below??

Cheers,
Willem

 

[MarkK]

No worries. Use the latter. Don't even assign the string to a variable first.

CurrentDb.Execute _
  "DELETE FROM tblAnywhere"

 

[Willem!]

Thanks! Your shorter code is even nicer, I implement it right away