Copy Database Structure

[Melissa]

I have created an Access database that some other
entities are interested in. However, their data is
unique. Therefore, I need to provide them with an "empty"
database as far as records are concerned. The database
contains 13 tables and approx. 20 forms, 30 reports, and
50 queries. I know that you can copy and paste the
structure only of a table.

Can you copy an entire database (structure only)
including all tables, queries, forms, reports, macros,
properties, relationships, etc?

If so, how specifically would you do it?

THANK YOU!!!!

 

[Graham Mandeno]

Hi Melissa

Create yourself a new, empty database and import all the objects from the
original (File>Get External Data>Import). You will have to visit each tab
in turn and click "Select All". Before you hit the OK button, click
Options>> and select "Definition Only" under "Import Tables". Make sure you
are importing relationships, and also Menus/Toolbars and Im/Ex Specs if
you're using them.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

 

[Melissa]

Graham:

You rock! (That's an American term meaning you are the
best!!!!!!)

Thank you, thank you, thank you.

Melissa

-----Original Message-----
Hi Melissa

Create yourself a new, empty database and import all the objects from the
original (File>Get External Data>Import). You will have to visit each tab
in turn and click "Select All". Before you hit the OK button, click
Options>> and select "Definition Only" under "Import Tables". Make sure you
are importing relationships, and also Menus/Toolbars and Im/Ex Specs if
you're using them.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

I have created an Access database that some other
entities are interested in. However, their data is
unique. Therefore, I need to provide them with an "empty"
database as far as records are concerned. The database
contains 13 tables and approx. 20 forms, 30 reports, and
50 queries. I know that you can copy and paste the
structure only of a table.

Can you copy an entire database (structure only)
including all tables, queries, forms, reports, macros,
properties, relationships, etc?

If so, how specifically would you do it?

THANK YOU!!!!

.