Open mdb XP with Access97

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • BT
    #1

    Open mdb XP with Access97

    Hello,
    I receive office files created by office versions newer than my Office 97.
    Is there tool to convert the newer to the older format so I can open and
    work with these files? (other than buying the new office of course :-)) )
    My PC runs windows 98
    Thanks
    BT


    Tags: None
    • Rick Brandt
      #2
      Re: Open mdb XP with Access97

      "BT" <bt@hotmail.com > wrote in message
      news:1078313643 .238233@athnrd0 2.forthnet.gr.. .[color=blue]
      > Hello,
      > I receive office files created by office versions newer than my Office 97.
      > Is there tool to convert the newer to the older format so I can open and
      > work with these files? (other than buying the new office of course :-)) )
      > My PC runs windows 98
      > Thanks
      > BT[/color]

      Nope. The only tool that can convert an Access 2002 (XP) file to 97 is Access
      2002 (or higher?).


      --
      I don't check the Email account attached
      to this message. Send instead to...
      RBrandt at Hunter dot com


        Comment

        • Rich P
          #3
          Re: Open mdb XP with Access97

          Actually, there is a way to convert this data without having to buy any
          new software. The catch is that you have to write a little bit of code
          to do it.

          GoTo MSDN and download Mdac2.5 and Mdac2.6. This is so you can use COM
          based ADO (as opposed to ADO.Net) to access your Acc2002 table. Mdac2.5
          contains Jet4.0, Mdac2.6 is an update for COM ADO. I do this all the
          time because at my workplace we also use Office97 (and I'm using .Net to
          interface with Sql Server - what a mix!). Here is a provider string for
          Acc2002 table.

          --------------------------------------------------
          Sub Get2002Data()
          Dim cmd As ADODB.Command, RS1 As ADODB.Recordset
          Dim RS2 As DAO.Recordset, i As Integer
          Set RS2 = CurrentDB.OpenR ecordset("tbl97 ")
          Set cmd = CreateObject("A DODB.Command")
          cmd.ActiveConne ction = "Provider = Microsoft.Jet.O LEDB.4.0; Persist
          Security Info=false;" _
          & "Data Source=C:\Dir1\ acc2002.mdb"
          cmd.CommandType = adCmdText
          cmd.CommandText = "Select * From tbl2002"
          Set RS1 = cmd.Execute
          Do While Not RS1.EOF
          For i = 0 to RS1.Fields.Coun t - 1
          RS2(i) = RS1(i)
          Next
          RS2.Update
          RS1.MoveNext
          Loop
          RS2.Close
          RS1.Close
          cmd.ActiveConne ction.Close
          End Sub
          ----------------------------------------------

          When you load Mdac you have to make a reference to Microsoft ActiveX
          Data Object 2.6 Library in Tools/References of your code module.


          Rich

          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            Previous template Next
            Working...