Difference between using or not field in delete statement RRS feed

  • Question

  • Hi all

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

    DELETE field FROM Table;


    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. 


    Joao Simplicio Rodrigues

    Friday, April 27, 2018 1:36 PM


All replies

  • No difference.

    Please quote any error message VERBATIM.

    -Tom. Microsoft Access MVP

    Friday, April 27, 2018 2:15 PM
  • Tom,

    Verbatim Ok 

    and Thank you.

    Joao Simplicio Rodrigues

    Friday, April 27, 2018 4:38 PM
  • 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).


    Friday, April 27, 2018 5:22 PM