ADODB and Access 97 Problem

Posted on 2004-10-21
Last Modified: 2010-04-17
Using VB6.  Developed a simple prg for use at my office.  Overcame a setup problem (thanks guys), but now have a different problem.

My machine at home has XP Pro and MSOffice 2003.  So my dbconnection is to a MSAccess 2003 db.  At the office I have Windows ME and Windows 98, both with Office 97.  Compiled and loaded, the prg works perfectly at home.  I converted the db to Access 97, recompiled and packaged.  Took it to the office.  It loaded ok and went through its steps, but now it does not load the data to the tables in the Access 97 db.  Is there a problem in using ADO with 97?  All code remains the same as at home, but Access 97 did notify me that changes were made to the code for the db.

What do I need to do???....jb
Question by:DrJax
    LVL 14

    Expert Comment

    by:Farzad Akbarnejad
    You can opening Access 97 database format in Access 2000 or 2003 as read only file. If you want to make changes to database you must convert the 97 format to 2000 or 2003 format.

    LVL 5

    Expert Comment

    That is correct if you want to make changes in Microsoft Access itself.
    You can access and change data as well as table structures using ADO with Micosoft Access 97 and >=2000.

    I'm not sure what u're doing with the data. Do you receive error messages on creating the connection and/or recordset objects? If so, this might be because u're probably refering to an ADO library 2.x where x is higher than the latest ADO drivers installed on the computers at the office. ie: you developed at home, refering ADO 2.8, while the latest version at the office might be 2.5.

    U can use ADO 2.5, 2.6, 2.7, 2.8, ... to connect to Access 97 AND Access 2000 databases. No problem at all...

    Another thing is the connection string. The database provider may be Jet 3.51 (Access 97 only) or Jet 4.0 (Accesss 97 and Access 2000 or higher).

    For your information, Access 2000 is fully INcompatible with Access 97 due to significant changes in the Microsoft Access object library. Access 2002 and access 2003 ARE fully backward compatible with Access 2000.

    If you could provide us more information about what u're doing with the databases and what errors you get then I'll probably be able to help you some more.


    LVL 5

    Expert Comment

    ...if it's the ADO version, you should install the latest MDAC drivers from microsoft. Currently, that version is 2.8:
    LVL 1

    Expert Comment

    If your probelm is still  not solved plz let me know the connection string you are using.


    Author Comment

    IThema:  Downloaded the 2.8 version.  Tried to load.  Received the following error....."MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows."  I don't understand, since my setup list shows MDAC 2.0????

    sandygad:  Connection string is ....
    Set conData2 = New ADODB.Connection
        With conData2
            .Provider = "Microsoft.Jet.OLEDB.4.0"
            .ConnectionString = "Data Source=C:\Program Files\Progress Notes\patient info2.mdb"
        End With

    The prg runs on the new machine with 98 & ME, but does not save the data to the the report prints blank.  I'll be happy to send the vbp to anyone who wants to check it out.  It's just for use at my office, but we have different operating systems.....jb
    LVL 1

    Accepted Solution

    Hi Dr

    your code says
     .Provider = "Microsoft.Jet.OLEDB.4.0"

    please try the following line instead of this
     .Provider = "Microsoft.Jet.OLEDB.3.8"

    if wont work then you can send me your project files at
    LVL 5

    Expert Comment

    U could also send me a sample:
    Please also state where things go 'wrong' or not as expected...
    Of course, I will treat your files confidentially

    Sandygad could be right about OLEDB.4.0. It might not work on W98 and ME (What DOES work on Windows ME? :s). I've had a dozen of projects on MSA 2000 and 97, but none of them using W98, ME...

    Worst case, you need to write code that uses different provider-versions for different operating systems... I once had code to do that... I'll try to find it.

    Maybe you could also try .Provider = "Microsoft.Jet.OLEDB", so you include no version. This is the version independant ProgID. Windows should automatically take its latest version if I'm not mistaken. When searching for "Microsoft.Jet.OLEDB.4.0" and "Microsoft.Jet.OLEDB.3.51" in the registry I get the same version independant ProgID, namely "Microsoft.Jet.OLEDB", so I figure that'll work...


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    856 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now