Copy complete Access database - structures only

[Guest]

Does anyone have an easy way to copy an Access database including
relationships to another Access database but only the structures, ie, no
data? TIA!
Leslee

 

[Dirk Goldgar]

Does anyone have an easy way to copy an Access database including
relationships to another Access database but only the structures, ie,
no data? TIA!
Leslee

Create a new, empty database. Open that database as the current
database, click File -> Get External Data -> Import..., and choose to
import from the database you want to copy. Select all the objects on
each tab of the import dialog. Then click the "Options >>" button, make
sure all the optional items are checked (like Import/Export Specs), and
in the Import Tables option group, choose Definition Only. Then click
OK to import the lot.

 

[Guest]

The easiest way I know is to create a new database, select File / Get
external data / import. Select the database you want to copy in the import
window. When the import objects window pops up click options and select
definition only for the tables. Then select all for each tab and import.

 

[Guest]

Thanks, Dirk! So easy when you know how to do it!
Leslee

 

[Guest]

Thanks, schasteen! I used Dirk's method which looks pretty close to yours and
it worked fine.
Leslee