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.

We create databases large and small. Some of our databases help run entire small businesses. We also handle unique businesses such as flyrod manufacturing, cheese making, marina management, and cable tv inventory.

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