I have a linked table which I want to make a phsical copy of. I have a piece of code which takes a copy of the table, but instead of an actual physical copy, the database purely creates another link to the table and renames it. What I need is a for a backup of the table, not another link. Can anyone tell me ho wI would modify my piece of code, or suggest a new way of doing this?
DoCmd.TransferDatabase acExport, "Microsoft Access", CurrentDb().Name, acTable, strTable, strTable & "_backup", False