wrong

put this before: docmd.setwarning false

put this after: docmd.setwarnings true

If you are using a MakeTable query, then you actually need to remove the
old temp table rather than empty it: for that you would need a DROP TABLE
command not a DELETE FROM.

On the other hand, emptying the table is probably quicker and safer as
long as the other query is an INSERT rather than a SELECT INTO (i.e.
append query rather than make table).

Finally, SetWarnings is a terribly dangerous method, because sooner or
later the warnings get left off and then you delete all your customer
data by accident. It's far better to use the .Execute method since that
gives you a trappable error too.

Try something like this:

 set db = CurrentDB()

 ' remove the old table
 jetSQL = "DROP TABLE MyTempTable"
 db.Execute jetSQL, dbFailOnError

 ' run the maketable query
 set qdf = QueryDefs("MyMakeTableQuery")
 qdf.Execute dbFailOnError

 ' and check it all
 debug.print DCount("*", "MyTempTable")

A better solution, though, is to create a brand new mbd to hold the temp
table each time and delete it when the applicatioin closes. Recurrent
emptying and loading tables leads to bloated files; dropping and creating
objects bloats them even faster; and both increase the risk of file
corruption. Take regular backups!

Hope that helps

Tim F