VBA script to Convert access2000 db to Access 97 db

[ajv]

I need to convert a access 2000 db to access 97 db in a production application. I would like to run a access macro or VBA code instead of going through the menu tree to do the following:

Input access 2000 db c:\mydb2000.mdb
Output access 97 db c:\mydb97.mdb

Thanks.

 

[mikeyb540]

Try this code with Command Button.

Private Sub Command0_Click()
Dim acApp As Access.Application
Set acApp = CreateObject("Access.Application&quot
SendKeys PathOld & "C:\MyDirectory\"
SendKeys PathNew & "C:\MyDirectory\"
acApp.DoCmd.RunCommand acCmdConvertDatabase


End Sub

 

[ajv]

Thanks. I think acApp.DoCmd.RunCommand acCmdConvertDatabase
will convert access97 to access2000. I need to convert access2000 to access97.