copy table 2

[samotek]

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

 

[PHV]

DoCmd.RunSQL "SELECT * INTO tblObsoleteClients FROM tblClients WHERE 1=2"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[zevw]

This is exactly what I needed.

Thanks