How do I delete all data in access?

  • Thread starter Thread starter Josh Ann
  • Start date Start date
J

Josh Ann

Can anyone offer me advice about how to wipe all the data
out of my access database? All data can be removed as it
changes each summer.
Thanks. Any advice is much appreciated.
 
Josh,

Start ny making a new, blank database that will be your new database. Go
File > Get External Data > Import; when the import wizard pops up, click
on Options and select option Definition Only in the Import tables option
group; then click Select All, and go through all tabs clicking Select
All on each; finally click OK. The only thing left to do is add any
references or change startup options as per the existing database, if
different to the defaults.

HTH,
Nikos
 
Back
Top