Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    SE England
    Posts
    3

    Question Unanswered: Access Data Project (ADP) to an Oracle database

    Using Access Data Project to Oracle

    I have an ADP project attached to a SQL database, for producing reports (works fine over remote connections), but I now need it to work on Oracle

    How do I run reports from an ADP front end using an Oracle database?

    I can access data in the Oracle tables with ADO recordsets, but how would I run reports, as Access reports require an attached table/view?

    Is their an OLE DB Provider for Oracle that will work with ADP's?

    I'm using Access 2000, connecting to Oracle 8

    Any ideas


    Steve
    Last edited by Steve_T; 12-17-03 at 07:25.

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    You can use the Oracle OLE DB driver supplied on the Oracle 8i/9i client. You can then create linked tables against which your reports should be able to run.

    Alan

  3. #3
    Join Date
    Dec 2003
    Location
    SE England
    Posts
    3
    Thanks Alan

    I have Oracle OLE driver 8i, but I am still unable to get the Oracle tables to connect, Works fine in an Access.MDB but not in an Access ADP project

    I'm trying to connect Dynamically in code

    Steve
    Last edited by Steve_T; 12-22-03 at 12:54.

Posting Permissions

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