Mega Code Archive
Copies a database object into the same or another database
Public Sub MakeBackupCopy()
DoCmd.CopyObject , "Employees Backup", acTable, "Employees"
DoCmd.SetWarnings False
DoCmd.OpenQuery "UpdatePrices"
DoCmd.SetWarnings True
End Sub