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

G

greglisasm

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.
 
Top