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.