topic-33349

Posts: 708

Joined: Fri Oct 28, 2005 09:53 AM

Conversion of access 97
Posted: Fri Dec 16, 2016 07:41 PM

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,

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: Conversion of access 97
Posted: Fri Dec 16, 2016 10:09 PM

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 (fw): Select all Collapse

// 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)

FiveTech Support Forums

Continue the discussion