Application.ConvertAccessProject

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ConvertAccessProject 1
Ideas about how to make 'Application.ConvertAccessProject' behave? 5
New to this 2
Calendar control conversion issue 3
Conversion to MS-Access 2003 4
disappearing Built-in functions 8
Should I convert 2000 and 2003 dB to Access 2007? 5
Access 2003 1

Top