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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Stops Downloading emails 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Converting data to appear in uppercase letters in a table 7
Showing the actual database, not access's idea of it... 4
Restrict Choice in Shared WB (drop down alternative)? 0
unable to enter data in Access 2007 database on network 2
Unable to enter data in Access 2007 database on a network 2
How do convert a MS Works Database to Office database? 5

Back
Top