Exporting database w/o data

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

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
 
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.
 
Back
Top