Conflicts with Access97 and Access2003

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ramchandar
    New Member
    • Dec 2007
    • 11
    #1

    Conflicts with Access97 and Access2003

    Hi,
    I am creating reports using VBA code.
    I have the same query in a querydef residing both in Access97 and Access2003. The result of this querydef is then moved to a table in Access97 and Access2003 respectively. The table in Access97 returns 874 rowcount, table in Access 2003 returns 1050 rowcount. In both the case the querydef is retrieving from the same database which resides in SQL Server 2003.

    I executed the application Access97 and Access2003 individually and tried to capture the query executed through SQL profiler. In both the case the same query is executed with rowcount 1050 in SQL Server 2003. But I am not able to find why this confict occurs though the same query used in querydef which is in both Access97 and Access2003.

    I am badly in need of help. Please help me to fix this issue.

    With regards,
    ram
    Tags: None
    • puppydogbuddy
      Recognized Expert Top Contributor
      • May 2007
      • 1923
      #2
      Originally posted by Ramchandar
      Hi,
      I am creating reports using VBA code.
      I have the same query in a querydef residing both in Access97 and Access2003. The result of this querydef is then moved to a table in Access97 and Access2003 respectively. The table in Access97 returns 874 rowcount, table in Access 2003 returns 1050 rowcount. In both the case the querydef is retrieving from the same database which resides in SQL Server 2003.

      I executed the application Access97 and Access2003 individually and tried to capture the query executed through SQL profiler. In both the case the same query is executed with rowcount 1050 in SQL Server 2003. But I am not able to find why this confict occurs though the same query used in querydef which is in both Access97 and Access2003.

      I am badly in need of help. Please help me to fix this issue.

      With regards,
      ram
      See if this link is any help:

      Microsoft Access Flaws - Records missed by SELECT query
      http://allenbrowne.com/bug-10.html
      Describes a bug in the query engine in Microsoft Access where it fails to return records for an outer join that is based on a literal value or calculated field.

        Comment

        • Ramchandar
          New Member
          • Dec 2007
          • 11
          #3
          No this url tells in general about the usage of join in Access.

          I think you didnt got wat i am expecting for.
          Any one please help.. i am badly in need of the solution for this.

          Thanking in advance,

          With regards,
          ram

            Comment

            • puppydogbuddy
              Recognized Expert Top Contributor
              • May 2007
              • 1923
              #4
              Originally posted by Ramchandar
              No this url tells in general about the usage of join in Access.

              I think you didnt got wat i am expecting for.
              Any one please help.. i am badly in need of the solution for this.

              Thanking in advance,

              With regards,
              ram
              Ok, please post the sql of your queries, so we can analyze them.

              PDB

                Comment

                Previous template Next
                Working...