1 Previous Next 

Convert MS Access DataBase to another version format (also to 2007) in Visual Basic Code


Often is asked in the forums how to handle an MS Access 2003 file and an MS Access 2007 file.

There is a very simple way to convert those. Be aware it is possible that methods from one are not available in the other and are therefore then not always converted.

Option Strict On
'Set a reference to Microsoft.Office.Interop.Access
Imports Microsoft.Office.Interop.Access
Module Module1
    Sub Main()
        Dim theAccessObject As New Application
        theAccessObject.ConvertAccessProject("C:\Test1\nwind.mdb""C:\Test1\nwindAcc.accdb"AcFileFormat.acFileFormatAccess2007)
    End Sub
End Module



1 Previous Next