copy linked table to a local table

[AT76]

Hi,

I'm trying to copy a linked table to a local table via: DoCmd.CopyObject. The problem is the new created table also has the linked properties. Could someone help me with the correct syntax so the new table is not linked but local?

Thank you!

 

[PHV]

Why not simply a MakeTable query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AT76]

Yes, you are right. I will do a MakeTable query