Application.SaveAsTemplate method (Access)
Converts an existing Microsoft Access database file to a database template (*.accdt) format file.
Syntax
expression.SaveAsTemplate (Path, Title, IconPath, CoreTable, Category, PreviewPath, Description, InstantiationForm, ApplicationPart, IncludeData)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Path | Required | String | The full path and file name of the database template to create. |
| Title | Required | String | The name of the database that is created when the user instantiates the template. |
| IconPath | Required | String | An image file to be used as an icon for the database template. |
| CoreTable | Required | String | The table that contains the data that users would most want to create a relationship with when they instantiate the template. The ApplicationPart argument must be set to True if you use this argument. |
| Category | Required | String | The template category under which the database template will appear on the Available Templates page. |
| PreviewPath | Optional | Variant | An image file to be used as a preview for the database template on the Available Templates page. |
| Description | Optional | Variant | A description to be displayed when the user selects the database template on the Available Templates page. |
| InstantiationForm | Optional | Variant | Specifies the name of the form to be displayed when the template is instantiated. |
| ApplicationPart | Optional | Variant | Specifies whether the template will be displayed when the user chooses Application Parts in the Templates group of the Create ribbon tab. Set to True to display the template when the user chooses Application Parts. |
| IncludeData | Optional | Variant | Specifies whether the table data is included in the template. Set to True to include the table data. |
Remarks
The SaveAsTemplate method replaces the SaveAsTemplate method that was installed with the Microsoft Office Access 2007 Developer Extensions.
Templates created by the SaveAsTemplate method cannot be used in Microsoft Office Access 2007 or earlier versions.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.