Results 1 to 8 of 8
  1. #1
    gjgiever
    Guest

    Link to Paradox tables

    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?

  2. #2
    New Lounger
    Join Date
    Aug 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to Paradox tables

    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.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to Paradox tables

    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

  4. #4
    gjgiever
    Guest

    Re: Link to Paradox tables

    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.

  5. #5
    gjgiever
    Guest

    Re: Link to Paradox tables

    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.

  6. #6
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link to Paradox tables

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

    FWIW

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Link to Paradox tables

    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.
    Charlotte

  8. #8
    zxis
    Guest

    Re: Link to Paradox tables

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •