A amator Registered User. Local time Today, 04:27 Joined Aug 1, 2006 Messages 23 Nov 7, 2006 #1 Hi. How I can delete all rows from my table whit on query? Also I want that when I delete rows from my table index and other settings will stay in table.
Hi. How I can delete all rows from my table whit on query? Also I want that when I delete rows from my table index and other settings will stay in table.
FoFa Registered User. Local time Yesterday, 20:27 Joined Jan 29, 2003 Messages 3,672 Nov 7, 2006 #2 DELETE FROM TableName (Maybe Access is DELETE * FROM TableName). If you go into query design, select QUERY from the menu, you can selet DELETE query.
DELETE FROM TableName (Maybe Access is DELETE * FROM TableName). If you go into query design, select QUERY from the menu, you can selet DELETE query.
