Exporting database w/o data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rachel - 29 Sep 2004 20:06 GMT

I would like to send a copy of an existing database to
someone, but without all the data in it. So I want the
format of all my tables, forms, reports, etc. to go, but I
don't want any of the data to be included. Is there a way
to do this?

Thank you!
-Rachel

Reply to this Message

John Nurick - 30 Sep 2004 06:23 GMT

Hi Rachel,

First, make sure your existing database is in good shape: make certain
there are no missing references or compile errors, and compact it.

Then create a new, blank database. Go to File|Get External Data|Import
and set about importing stuff from the old one. In the import wizard,
click the Options>> button and specify you want to import Definition
Only of tables, and import relationships, menus and toolbars. Then go
ahead and import all the tables, queries, forms, etc.

>I would like to send a copy of an existing database to
>someone, but without all the data in it. So I want the
[quoted text clipped - 4 lines]
>Thank you!
>-Rachel

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message