
How to copy structure of a table to another database
Quote:
> ...
> Does anyone know how to copy only the structure of a table (not the
> data) from one Access database to another using either SQL or DAO?
See help for TableDef object. Not directly mentioned as a TableDef's
properties (but shown in the picture) are its Fields and Indexes
collections, so don't forget about them!
--
Vox (0|+44)1642 216 200 }*|*{ *o|o* }o|o{ Zetland Buildings, Exchange Square
Fax (0|+44)1642 216 201 o o * Middlesbrough, Cleveland. TS1 1DE
"Imitation is the sincerest form of being a thieving bastard." -- somebody else