Is it possible to make a template of a db to share

[Gomer Fackworth]

WE have a historical center and another group in another town has an Access 2000 db that they would be willing to share the structure with us, but not the data. Is it possible to make a template or to export the structure without the data?

[markajm]

simplest way would be to have them make a copy of the database, open each table and select all (ctrl-a), delete, save.

then run compact and repair under the tools menu and send you the copy.

you will have all the structure but no data.

[Gomer Fackworth]

Much obliged, Mate