Convert Access 97 to Access 20003

[JuriSim]

Hello,

A few years ago I have made a program made in Access 97 (front end and back end; both in Acc 97 db format).
Now we want to upgrade to Access 2003. (The reason why we don't upgrade to 2007 is: some of our clients use Windows Server 2003)

I know there is a converting tool in Access 2003 to convert from 97 to 2003.

The only problem is: our clients do not have a full Access 2003, but use the Acc 2003 Runtime. Therefore I am looking for a converting tool to convert the acc97 db's to acc 2003 format. This converting tool should be processing in background.

The converted program will be installed, using Acc 2003 Dev Extensions: Package Wizard. In this wizard I can give some commands to start EXE's after installation.

I would be very usefull to find some VB-code which I can use to convert the acc 97 to acc 2003 format.

Any help, suggestions, ideas are welcome

Thanks in advance

Kind regards ,
Juri

 

[JuriSim]

Hello,

I found the solution myself.
For the persons who are interested:

'Run the following code from a blank database:
Dim appAccess As New Access.Application
Dim xSource As String
Dim xDestination As String

xSource = InputBox("Please enter path+file which you want to convert", "Source file")
xDestination = InputBox("Please enter path+file for new file", "Destination file")
appAccess.ConvertAccessProject xSource, xDestination, acFileFormatAccess2002