Conversion of access 97

[cdmmaui]

Hello,

Does anyone have a utility or know where I can get a utility to convert a Access 97 MDB to a current version of Access MDB?

Thank you,

[Rick Lipkin]

Darrell

Your best bet is to buy Office Pro 2007 or greater. When you open your old .Mdb in 2007 or greater .. you should be able to 'save as' to upgrade your old .mdb 97 to .mdb 2003. Stay with the .mdb format and not upgrade to .acctdb. AccDb will not work with MS Jet and you will have to add the Ms Ace OleDb to your distribution.

Rick Lipkin


ps .. you can also do the upgrade programatically .. create a new .mdb and then write a routine to append over the old data.

Code: Select all  Expand view

// create the adox object
      Try
         catNewDB := CreateObject("ADOX.Catalog")
      Catch
         MsgInfo( "Could not Create ADOX object")
         oDLG:End()
         Return(.f.)
      End try

      // create the table Vehicle.Mdb
      Try
        catNewDB:Create('Provider='+xProvider+';Data Source='+xSource+';Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password='+xPASSWORD )
     Catch
         MsgInfo( "Could not create the table "+xSource )
         oDLG:End()
         Return(.f.)
      End Try

      cSay := "Created "+cDefa+"\Vehicle.Mdb"
      oSay:ReFresh()
      SysReFresh()

      catNewDB:ActiveConnection:Close()
      catNewDB := nil
      SysWait(.5)