>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com