>Microsoft Access: DELETE * FROM TABLE_NAME

The * is a common mistake that most people do. It is doesn't make sense because you cannot delete only a couple of fields. It is so common that Access simply ignore it.


>>Does VB have some method to delete all the records inside a table Like "Zap" for DBF database?

If you are using Access, don't forget to use the CompactDatabase method once in a while because records are deleted but space is not freed.