Hi, i have a linked table called estimates in my front end database, i want to make a local copy of it.
DoCmd.TransferDatabase acExport, "Microsoft Access", CurrentDb.Name, acTable, "Estimates", "Estimates_Copy", StructureOnly:=False
The following Code makes a copy called Estimates-copy but the table is still a linked one not a local. Can someone help, thanks.