Copy complete Access database - structures only

L

LesleeT

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
 
D

Dirk Goldgar

LesleeT said:
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
Click to expand...

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

schasteen

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

LesleeT

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