Application.ConvertAccessProject

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I need to be able to convert Access Databases to '97 format. I am using
Access 2007.

I know that the Access 2007 GUI, doesnt allow this (2000 and above only).
But found in the VBA Code the below.

Application.ConvertAccessProject

expression.ConvertAccessProject(SourceFilename, DestinationFilename,
DestinationFileFormat)

Options for the DestinationFileFormat, are given as

acFileFormatAccess12 (Ver. 2007)
acFileFormatAccess2 (Ver. 2.0)
acFileFormatAccess2000 (Ver. 2000)
acFileFormatAccess2002 (Ver. 2002)
acFileFormatAccess95 (Ver. 95)
acFileFormatAccess97 (Ver. 97)

As you can see '97 is listed. This is listed on the 2007 helpfiles.
However the acFileFormatAccess97 fails to work (2000 works fine). Is there a
work around for this ?
 
Back
Top