Export an Access database structure (i.e. no data)?

[Rhythmdvl]

If I want to duplicate just a table, I can easily select "structure only" under paste options. Is there an easy way to do the same thing for an entire database (tables, queries, etc.) all at once?

In short, someone has a database. They're willing to share the database itself, but not necessarily its contents. The database has a user interface, so the people who use the database don't necessarily know much about Access. Therefore, I can ask them to follow a few basic, built-in Access menu options, but can't ask them to do something manually, such as copying the entire file and then manually emptying the tables. This seems like something that should be easy, but I can't find it. Any help?

Thanks,

Rhythm

 

[boblarson]

If you want to do it programmatically, check out the
DoCmd.TransferDatabase
method.

You would have to use a line for each object but it could be done.

 

[Rhythmdvl]

Ouch, methinks.

I'm awfully sorry to be pedantic about this, but I'd like to be sure I explained myself before I give up the proverbial ghost. There's no built-in function to flush all tables?

This is something I could do myself, but since the people I'm asking are not my client, are doing my client a favor (we're all non-profits so there's a lot of goodwill, but bureaucracies being what the are, sending all stakeholder information is not really feasible), are halfway around the world, and would not appreciate any more instructions other than go to Tools>etc., I'll just have to give up the ghost.

That it's a problem seems somewhat counterintuitive to me. That is, my intuition (I know, I know...) suggests that sharing a database so that it can be populated by different people, should be easy--hence I'm questioning whether or not I asked the question clearly.

Rhythm

 

[boblarson]

No, there's no built in way to flush the data. You would have to either export the structure to another database or use delete queries to remove the data.

 

[RuralGuy]

You could create a new mdb and import just the structure of the tables. It is under the Options>> button on the Import Objects dialog form. Or did I just completely misunderstand the problem?