Export (0) Print
Expand All
Expand Minimize

Application.ConvertAccessProject Method

Office 2007
Converts the specified Microsoft Access file from one version to another.

Syntax

expression.ConvertAccessProject(SourceFilename, DestinationFilename, DestinationFileFormat)

expression   A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
SourceFilenameRequiredStringThe name of the Access file to convert. If a path isn't specified, Access looks for the file in the current directory.
DestinationFilenameRequiredStringe name of the file where Access saves the converted file. If a path isn't specified, Access saves the file in the current directory.
DestinationFileFormatRequiredAcFileFormatAn AcFileFormat constant that specifies the format of the converted file.

Return Value
Nothing

Remarks

The file specified by DestinationFilename cannot already exist, or an error occurs.

Example

The following example converts the specified Access 97 file to an Access 2000 file in the same directory.

Visual Basic for Applications
Application.ConvertAccessProject _
    SourceFilename:="C:\My Documents\Sales-Access97.mdb", _
    DestinationFilename:="C:\My Documents\Sales-Access2000.mdb", _
    DestinationFileFormat:=acFileFormatAccess2000


Community Additions

ADD
Show:
© 2014 Microsoft