Is there any way to check if a table exist aand if so delete it?
I was thinking this might do it:

VB Code:
  1. If CurrentDb.TableDefs(TempTable).Name > "" Then
  2.      DoCmd.RunSQL "DROP TABLE TempTable;"
  3. End If

but that hangs!