>>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

I did not know that it was a msitake and that Access ignores it. For some reason I ws lead to believe that it was required. Go figure.