Application.ConvertAccessProject (Access)
Converts the specified Microsoft Access file from one version to another.
The file specified by DestinationFilename cannot already exist, or an error occurs.
ConvertAccessProject (SourceFilename, DestinationFilename, DestinationFileFormat)
Application.ConvertAccessProject _
SourceFilename:="C:\My Documents\Sales-Access97.mdb", _
DestinationFilename:="C:\My Documents\Sales-Access2000.mdb", _
DestinationFileFormat:=acFileFormatAccess2000
Arguments
The following arguments are required:
SourceFilename (String) - The name of the Access file to convert. If a path isn't specified, Access looks for the file in the current directory.
DestinationFilename (String) - The name of the file where Access saves the converted file. If a path isn't specified, Access saves the file in the current directory.
DestinationFileFormat (AcFileFormat) - An AcFileFormat constant that specifies the format of the converted file.
Possible values are
acFileFormatAccess2 | Microsoft Access 2.0 format |
acFileFormatAccess2000 | Microsoft Access 2000 format |
acFileFormatAccess2002 | Microsoft Access 2002 format |
acFileFormatAccess2007 | |
acFileFormatAccess95 | Microsoft Access 95 format |
acFileFormatAccess97 | Microsoft Access 97 format |