How to erase data from a database but keep the format

D

Doglover

I am an Access novice. I inherited an old database I no longer need. I need
to create a new database. I want to keep the format of the database, but
erase the old data. Can that be done? What is the most simple way?
 
F

fredg

I am an Access novice. I inherited an old database I no longer need. I need
to create a new database. I want to keep the format of the database, but
erase the old data. Can that be done? What is the most simple way?

Simple for who?
A 'simple' way is to open each table in turn. Select all the data.
Delete.
Next table.
If a table is related to another table, always delete the many side
(sub) table before the primary (master) table.

Another simple way is to create a new database. Then use
File + Get External Data + Import
Navigate to the existing database.
Select all the tables. Click on Options.
Select Data Definition Only.
Then select all of other objects in the database.
Click OK.
 

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