Show All

Save a database object as another object type

If the database object is open, you must save your changes before you save it as another object.

1. In the Database window, under Objects, click the type of object that you want to convert.

2. In the Object list, click the object that you want to save as another object type, and then click Save As on the File menu.

3. In the Save As dialog box, type a unique name in the Save <object name> To box, and then click the object type that you want.
4. If you are in a Microsoft Access database that is a Design Master, and if you want the new object to be replicated to other databases, select the Make Replicable check box.
5. Click OK.
6. If you chose to save the object as a data access page, in the New Data Access Page dialog box, type a name for the page. If a default page folder is specified in the Options dialog box (Tools menu), Microsoft Access will prompt you to save the page in the default location.

Access creates the database object and opens it in an appropriate view. If the new object is a page, Access also creates a shortcut for the page in the current database.

Note  You cannot save a data access page or a module as another object type.