The DoCmd.CopyObject method does not have an argument that flags whether to
copy all the data, or just the structure. Is there a way in VBA code to
copy only the structure of a table, and not the data?

Many thanks,
Margaret

Hi,
perhaps you can first copy whole table, and then delete data.
other option - you have to write a code to go throught all fields,
properties, indexes, etc of a table and create same on a new one

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Margaret Bartley" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The DoCmd.CopyObject method does not have an argument that flags whether
> to copy all the data, or just the structure. Is there a way in VBA code
> to copy only the structure of a table, and not the data?
>
> Many thanks,
> Margaret
>

"Margaret Bartley" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)
> The DoCmd.CopyObject method does not have an argument that flags
> whether to copy all the data, or just the structure. Is there a way
> in VBA code to copy only the structure of a table, and not the data?

DoCmd.TransferDatabase will do it. Just specify the current database's
name as the target database, and specify True for the StructureOnly
argument. For example,

DoCmd.TransferDatabase _
acExport, _
"Microsoft Access", _
CurrentDb.Name, _
acTable, _
"Table1", _
"Table1_COPY", _
True

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Alex Dybenko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)
> Hi,
> perhaps you can first copy whole table, and then delete data.
> other option - you have to write a code to go throught all fields,
> properties, indexes, etc of a table and create same on a new one

There's a Microsoft KnowledgeBase article for Access 97 on how to do
this with DAO:

http://support.microsoft.com/default...b;en-us;217011

I don't think there's a version of the article for Access 2000+, but I
imagine that article would work for these versions, too. However, using
TransferDatabase seems simplest.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Ooh, Thank You!!

"Dirk Goldgar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Margaret Bartley" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)
>> The DoCmd.CopyObject method does not have an argument that flags
>> whether to copy all the data, or just the structure. Is there a way
>> in VBA code to copy only the structure of a table, and not the data?
>
> DoCmd.TransferDatabase will do it. Just specify the current database's
> name as the target database, and specify True for the StructureOnly
> argument. For example,
>
> DoCmd.TransferDatabase _
> acExport, _
> "Microsoft Access", _
> CurrentDb.Name, _
> acTable, _
> "Table1", _
> "Table1_COPY", _
> True
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>