copy structure only

[samotek via AccessMonster.com]

My way of copying table structure only does not work with linked table.it
does copy the table but not structure only,and with everything with it.Coukd
i avoid that and copy a linked table structure only ?
DoCmd.TransferDatabase acImport, "Microsoft Access", CurrentDb.Name, acTable,
"tblClients", "tblObsoleteClients", True

 

[bhicks11 via AccessMonster.com]

TransferDatabase copies an entire database. What is your method of copying
the table structure of a linked table that isn't working. It works for me
when I do it manually.

Bonnie
http://www.dataplus-svc.com

 

[Marshall Barton]

My way of copying table structure only does not work with linked table.it
does copy the table but not structure only,and with everything with it.Coukd
i avoid that and copy a linked table structure only ?
DoCmd.TransferDatabase acImport, "Microsoft Access", CurrentDb.Name, acTable,
"tblClients", "tblObsoleteClients", True

A linked table's structure doesn't exist in CurrentDb.

You need to get it from the back end table. For a Jet BE,
the path to the BE database is in the linked table's Connect
property, which you can get by using:

Mid(CurrentDb.TableDefs("tablename").Connect, 11)