Edit

Application.SaveAsTemplate method (Access)

  • Article

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.