How do I copy an entire database structure without the data?

G

Guest

I have a database that I need to replicate every year with new data. How can
I copy the entire database structure(tables, queries, reports,etc.) without
the data?

I am using Access 2002.
 
A

Allen Browne

1. Create a new (blank) database.

2. Import from the old database:
File | Get External | Import

3. In the Import Objects dialog, click the Options button.
Under Import Tables, choose Definition Only.

4. For each of the tabs in the dialog, click Select All. Then 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