Copy Database Structure

  • Thread starter Thread starter Melissa
  • Start date Start date
M

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

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


.
Click to expand...
 
Back
Top