About copying a database object
You can easily customize an existing database object in a Microsoft Access database or Microsoft Access project by creating a copy of that object and modifying the copy. Also, you might want to make a backup copy of a database object. For example, you might want to make a backup copy before making design changes, or before running an append or update query that changes the data in a table.
A copy of the database object usually inherits the properties associated with the original database object. However, if you create a copy of a table in an Access project, the copy does not inherit the constraints and triggers of the original table. Also, if you create a copy of a table or query in an Access database, and you want a subdatasheet in the table or query to exist in the copy as well, you must open the copy and insert the subdatasheet.
When you create a copy of a data access page, Access prompts you to provide a name for the new HTML file.