Difference between using or not field in delete statement

Question

Hi all

In practical terms what is the difference between using a field in DELETE statement

DELETE field FROM Table;

or

DELETE FROM Table;

Unfortunately there is no TRUNCATE statement in Access

In Access 2010 (32 bits version) when I use DELETE * FROM Table; I often get the error "the database is in a format that can not be use...." or something like this. 

Thanks

---

Joao Simplicio Rodrigues

Answer 1

No difference.

Please quote any error message VERBATIM.

---

-Tom. Microsoft Access MVP

Answer 2

Tom,

Verbatim Ok 

and Thank you.

---

Joao Simplicio Rodrigues

Answer 3

I'm not sure what the difference is other than we can't delete a specific field from a table without using ALTER.  We can only delete the whole record.  I always use DELETE FROM <table> and never had any issues either in 2007, 2010 or 2013 (now using).

Mike