Export table and form definitions only

[Hanna]

Hi again,

I am trying to save a template from my old database. I need the table
definitions and form vews only. I don't want any data in it. Please let me
know how to do it if you know. Thanks in advance.

Hanna

 

[Jeff Boyce]

Hanna

This is a quick/dirty way to do that ...

Make a backup copy in Windows explorer.

Open the backup copy and delete all the data from the tables.

(now, WHY? Why are you attempting to make a second database exactly like
the first? Is there a chance you are "committing spreadsheet" on Access by
trying to set up a new "year's" database?)

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Linq Adams via AccessMonster.com]

Or you could do it the way Access is set up to do it!

Create a new, blank database

Goto File - Get External Data - Import

Select your original database file

After selecting the tables in question, click on

Options

and under

"Import Tables"

select "Definition Only"

Like Jeff, I'd have to ask "Why?" The only time I've ever done this was to
try a completely new approach to something that was in development. And
simply going into the Windows Explorer and copying the file with a different
name works just as well for that, following Jeff's instructions.