Copy paste a table with structure only 1

[wuwang]

Hi,

I'm trying to copy paste a table with structure only using DoCmd CopyObject but I received type mismatch error.

The command I use is :
appAccess.DoCmd.CopyObject "new table", acTable, "old table"

Is the CopyObject method that I should use?

Thank you for your help!

 

[PHV]

appAccess.DoCmd.CopyObject [!], [/!]"new table", acTable, "old table"

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

 

[wuwang]

It works. Thanks PHV.