How do I delete all data in access?

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.
 
N

Nikos Yannacopoulos

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
 
Top