By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,391 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,391 IT Pros & Developers. It's quick & easy.

Open mdb XP with Access97

P: n/a
BT
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"BT" <bt@hotmail.com> wrote in message
news:10***************@athnrd02.forthnet.gr...
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


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
Nov 12 '05 #2

P: n/a
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.OpenRecordset("tbl97")
Set cmd = CreateObject("ADODB.Command")
cmd.ActiveConnection = "Provider = Microsoft.Jet.OLEDB.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.Count - 1
RS2(i) = RS1(i)
Next
RS2.Update
RS1.MoveNext
Loop
RS2.Close
RS1.Close
cmd.ActiveConnection.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!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.