This documentation is archived and is not being maintained.

Application.ConvertAccessProject Method

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


expression.ConvertAccessProject(SourceFilename, DestinationFilename, DestinationFileFormat)

expression   A variable that represents an Application object.


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


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


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", _