Database structure

[Curtis McGrath]

how can I export my access 2000 database structure without having all the
old data

 

[Chriske911]

how can I export my access 2000 database structure without having all the old

data

create a new database and use file/get external data/import from the
toolbar
select all the stuff you need from the original database
click on the options on the right of the window
and below the import screen you can set the option to definition only

grtz

 

[Rick B]

When you go to import the tables, it will ask you if you want the data or
jsut the structure.

 

[Curtis McGrath]

thanks

create a new database and use file/get external data/import from the
toolbar
select all the stuff you need from the original database
click on the options on the right of the window
and below the import screen you can set the option to definition only

grtz

 

[Dirk Goldgar]

how can I export my access 2000 database structure without having all
the old data

Create the new database, and from within that database, use File -> Get
External Data -> Import... to import the tables and other object from
the old database. However, click the "Options >>" button on the Import
Objects dialog to show the options you can select, and choose the option
to import "Definition Only" for the tables, not "Definition and Data".