Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    3

    Question Unanswered: How can we connect an Access Front-End to a Progress 10.1a database via ODBC or ADO?

    Does anyone know how to implement the connection of an Access (VBA application) Front-End to a Progress 10.1a Database?

    We use MSAccess2007 (But could use older versions) with DataDirect Progress ODBC Client 5.09.00.37.

    We can connect to all the SYSPROGRESS tables but the PUB. ones are unaccesible to SELECT, UPDATE, INSERT and DELETE commands. We can only see it's structure.

    HELP Please!

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Yes. You need the Pervasive Driver (by Pervasive). Once installed, it will let you connect to Progress backend databases. You'll still use ODBC but you will select Pervasive as the driver. Then all is good and you can link in your Progress databases into MSAccess via the ODBC.

    Look at the websites (google) for Pervasive ODBC drivers that you would purchase.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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