Copy a database object within a Microsoft Access file
- In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.) under Objects, click the type of database object (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.) that you want to copy.
- In the Object list on the right side of the Database window, click the object and then click Copy on the toolbar.
If you are copying the object to a different Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.), close the current Access database or Access project, and then open the Access database or Access project into which you want to paste the object.
- Click Paste on the toolbar.
- Type a unique name for the object in the Paste As dialog box.
If you are in an Access database that is a Design Master (Design Master: The only member of the replica set in which you can make changes to the database structure that can be propagated to other replicas.), and if you want the new object to be replicated to other databases, select the Make Replicable check box.
Copy the structure of a table or append data to an existing table
Copy a database object to another instance of Access or to another Microsoft application