Emptying a database

T

tina

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
 

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

Top