Exporting database w/o data

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
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top