I am using DTS to import tables into my new database from another
database, both of which reside on the same server. All the tables,
fields and data copy over fine; however when I go into design view of
the copied tables, the default values for all the fields are lost. It
seems to copy the structure, but not the field properties.
I could manually set the values, but this could prove to be very time
consuming. Thought I may have overlooked a setting or simply missed a
Is it possible to have these properties copied over?
Any help/input would be appreciated.