Access Clear all records in access
- Thread starter frhnadz
- Start date
Take Backup of your database before its too late.
Go to create tab
create a query
suppose you want to delete all recs from table1
save the query , give it a purposeful name say deletor.
goto design view - sql view
type this line
DELETE *
FROM Table1
WHERE 1=1;
save it.
Now run this query. if you get a popup/alert click yes...all your precious records are gone...
Go to create tab
create a query
suppose you want to delete all recs from table1
save the query , give it a purposeful name say deletor.
goto design view - sql view
type this line
DELETE *
FROM Table1
WHERE 1=1;
save it.
Now run this query. if you get a popup/alert click yes...all your precious records are gone...
okay thanks for replying , sorry for inconvenience, I would like to make…the user the one who’s use my system clear up their record every year, I don’t want to clear the record , I just want the USER to clear up the records , so I think I would to make one button for them to clear all data/ record.. 