Argument | Description |
destinationdatabase | A string expression that's the valid path and file name for the database you want to copy the object into. To select the current database, leave this argument blank. |
If you execute Visual Basic code containing the CopyObject method in a library database and leave this argument blank, Microsoft Access copies the object into the library database. | |
newname | A string expression that's the new name for the object you want to copy. To use the same name if you are copying into another database, leave this argument blank. |
sourceobjecttype | One of the following intrinsic constants: |
acDefault (default) acForm acMacro acModule acQuery acReport acTable | |
sourceobjectname | A string expression that's the valid name of an object of the type selected by the sourceobjecttype argument. |
If you run Visual Basic code containing the CopyObject method in a library database, Microsoft Access looks for the object with this name first in the library database, then in the current database. |
DoCmd.CopyObject, "Employees Copy", acTable, "Employees"