Application.SaveAsTemplate Method (Access)

Converts an existing Access database file to a database template (*.accdt) format file.

Version Added: Access 2010

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 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 Application Part argument must be set to True if you set 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 in 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 clicks Application Parts in the Templates group of the Create ribbon tab. Set to True to display the template when the user clicks Application Parts.

IncludeData

Optional

Variant

Specifies whether the table data is included in the template. Set to True to include the table data.

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.

Show: