• Link to Paradox tables

    Author
    Topic
    #1767428

    I was recently asked to create some Access (97) reports from a Paradox program. Although I, apparently, have the driver loaded to access Paradox, Paradox does not show up as an option when I try to link to the tables. When I try to access them through ODBC, it shows that the drivers are loaded but won’t let me access them through ODBC. Help says that I have to select them from the drop down box. A check of the Microsoft support site was not helpful. Anyone out there have experience with this?

    Viewing 1 reply thread
    Author
    Replies
    • #1775165

      A client of ours researched this in early 2000 but discovered through their research and conversing w/Microsoft that no direct export or link is viable with Access 97. For their case, they found exporting to dBase IV then importing to Access 97 was very successful. Don’t know if it would work in your situation but if you could export to dBase IV from Paradox, the link to the dBase IV file you might get away with it.

      • #1775176

        Thanks. I’m begininning to believe it is not possible, too. But some say it can be done. I can’t figure out how they do it though. Maybe it is just not worth the bother.

    • #1775171

      Here’s what I’ve gotten to work. I don’t have the time to research this further. I loaded the Data Access pack from the ValuPack folder on the Office 97 CD. Paradox now shows up as a choice for importing or linking. However, if I use a Paradox 7 or 8 table, the driver doesn’t know how to handle it. The driver on the ValuPack is for Paradox 5 or older.

      I don’t know if that helps any, but I figured I would let you know what I ran into. (Using the AutoIncrement field in Paradox causes it to be saved as a version 7/8 Paradox db file)

      HTH, FWIW, My $.02

      • #1775175

        That’s the confusing part. I added the driver just like you did but it doesn’t show up as an option. I can’t figure out what is different for me.

        • #1775178

          Now I’m tired and this may sound stupid in the morning, but I have Paradox 8 loaded on my system.

          FWIW

          • #1775188

            It isn’t stupid at all. Having Paradox installed gives you the Borland Database Engine, which may be what makes it work for you. I know with Access 2000, you need the BDE to do anything more than look at the Paradox file.

            • #1779403

              Reply for Access 97 only. Just some simple requirements. Most of the limitations are due to Access, not Paradox.

              1. The Access ODBC drivers are 8.3 nameing convention!
              2. Need to have that primary key on the PDOX table.

              You should have no problem linking. You don’t even need the BDE on the machine with Access doing the linking. The BDE is the engine for PDOX so it is already on that machine.

    Viewing 1 reply thread
    Reply To: Link to Paradox tables

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: