ConvertAccessProject Method

Microsoft Access Visual Basic

Show All

ConvertAccessProject Method

       

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

expression.ConvertAccessProject(SourceFilename, DestinationFilename, DestinationFileFormat)

expression   Required. An expression that returns one of the objects in the Applies To list.

SourceFilename  Required 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  Required 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  Required AcFileFormat. The Access version of the converted file.

AcFileFormat can be one of these AcFileFormat constants.
acFileFormatAccess2
acFileFormatAccess2000
acFileFormatAccess2002
acFileFormatAccess95
acFileFormatAccess97

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.

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