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