Emptying a database

  • Thread starter Thread starter Steve Hayes
  • Start date Start date
the quickest, easiest way i know of is:

1. create a new, blank database.
2. from the database window, click File | Get Data | Import
3. in the Import dialog box, click the Options button and select Definition
Only under Import Tables. (if you have any custom menus and/or toolbars,
and/or any import specifications in the "old" database, make sure you
checkmark those boxes under Import.)
4. starting with the Tables tab, go through each tab and click the Select
All button.
5. then click OK.

your entire database will be imported - without any data in the tables.

hth


Steve Hayes said:
How does one empty a database in access -- ie remove all data from all tables?
uk
 
Back
Top