Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Thanked 0 Times in 0 Posts

    ambiguous joins (msaccess sr-2)

    I have a database that uses tables linked to Oracle. When I create queries that join the access tables with the Oracle tables there are usually no problems. I may run a query numerous times with no problems, then for no apparent reason I get the ambiguous join error message. Nothing seems to correct the problem. I may go back to the same query 2 or 3 days later and it runs with no problem. Any thoughts?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: ambiguous joins (msaccess sr-2)

    These kind of issues probably have to do with the condition of the Oracle database. In general, you don't want to do queries that involve local tables and tables in the database server, as that requires that the entire set of data be brought into Access so that the query can be run - that applies equally to both Oracle and SQL Server. The issue with joins most probably has to do with rekational data integrity issues in the Oracle database, at least that's typically what we see.

Posting Permissions

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