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.

You did not know that nearly 100 cable and satellite tv installers use our software to manage their device inventory. They never lose track of an expensive device.

We have expert enterprise-level database development capabilities for cloud/web-based databases through our partnership with Jay McCormick and his team.

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

acFileFormatAccess2
acFileFormatAccess95
acFileFormatAccess97
acFileFormatAccess2000
acFileFormatAccess2002
acFileFormatAccess2003

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