After Googling around, I'm stumped. I have some code that will copy my linked BE table with a button from the FE, but it is pasting it in the BE as a linked table. I want to create a back up of the table with a date stamp before importing updated data in the case the data is corrupt/inaccurate/etc. My code is below. Thanks in advance.
Code:DoCmd.CopyObject "NetworkPathtoBE\BE.accdb", Format(Date, "yyyymmdd") & "-Documents", acTable, "Documents"