I would like to Copy a Table, Rename Table and Still have the original Table. Would like to add this to a VBA, One other thing I would like to add is the NewTable name could be variable string + "NewTable". I've goggled and looked at many examples but can't seem to get it to work.
DoCmd.Rename "Old Table", acTable, "New Table"Thanks!
DoCmd.CopyObject, "Table Copy", acTable, "Table"
New Table = XX + "New_Table_Name"