Application.ConvertAccessProject method (Access)
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
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| 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 | An 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.
Application.ConvertAccessProject _
SourceFilename:="C:\My Documents\Sales-Access97.mdb", _
DestinationFilename:="C:\My Documents\Sales-Access2000.mdb", _
DestinationFileFormat:=acFileFormatAccess2000
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.