Nov 26, 2006 #1 keak Programmer Sep 12, 2005 247 CA Hi there, Is there a way in MS Access interface to delete all rows in a table? (leave the fields definitions in but an empty table) I've tried to look it up but can't seem to find a straight forward way to do it. any help is great!!! thanks
Hi there, Is there a way in MS Access interface to delete all rows in a table? (leave the fields definitions in but an empty table) I've tried to look it up but can't seem to find a straight forward way to do it. any help is great!!! thanks
Nov 26, 2006 #2 BradCollins Technical User Sep 2, 2003 116 AU Create a delete query on all records in your table DELETE tblTableName.* FROM tblTableName; Upvote 0 Downvote