Access ConvertAccessProject Method Example

Convert Access Project Method - Converts the specified Microsoft Access file from one version to another Access version.
Application.ConvertAccessProject(SourceFilename, DestinationFilename, DestinationFileFormat)

Where:

SourceFileName is the name of the Access database to convert. If a path is not specified the current directory will be assumed.

DestinationFilename The name of the file where Access saves the converted file. If no path then the current directory is assumed.

DestinationFileFormat Required AcFileFormat. The Access version of the converted file.  Valid entries are:

• acFileFormatAccess2

• acFileFormatAccess95

• acFileFormatAccess97

• acFileFormatAccess2000

• acFileFormatAccess2002

• acFileFormatAccess2003

Example:

Application.ConvertAccessProject("c:\mydbs\mydb_2000.mdb", & _
"c:\mydbs\mydb_2002.mdb",acFileFormatAccess2002