DoCmd.CopyObject

Copy a database object to a different Access database or to the same database or Access project (.adp) under a new name.

Syntax
      DoCmd.CopyObject(DestinationDatabase, NewName,
                     SourceObjectType, SourceObjectName)

Key
   DestinationDatabase
                    A string expression that’s the valid path and
                    file name for the destination database
                    To select the current database, leave this argument blank.

                    In an Access project/library (.adp) leave this argument blank.

   NewName          The new name for the object to copy.
                    default=same name as source.

  SourceObjectType  An AcObjectType constant that represents the type
                    of object to copy.

  SourceObjectName  The name of an object to copy.

Either destinationdatabase or newname (or both) must be specified.

If sourceobjecttype and sourceobjectname arguments are left blank, Access will copy the object selected in the Database window.

To select an object in the Database window, you can use the SelectObject action or SelectObject method with the In Database Window argument set to Yes (True).

Examples

DoCmd.CopyObject, "T_Patients Copy", acTable, "T_Patients"

“We could have saved the Earth but we were too damned cheap” ~ Kurt Vonnegut, Jr.

Related

DeleteObject - Delete an object