Results 1 to 4 of 4
  1. #1
    amlanroy is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    May 2012
    Posts
    2

    Post Access giving wrong result using sql query

    Hi,



    I am using a MS access mdb file to display some record from oracle database using odbc connection.
    But it is giving wrong result sometimes. below is the scenario:-

    I have a table (linked table) called map_detail in mdb as well as oracle with same table structure.
    I formed one query in mdb (sql query) select * from map_detail where batch_no="SSO15121".
    It is always fetching some other result, but when I am changing the query by changing the batch no "SSO15148"
    it is working fine. I noticed that for cases it working.

    Any help will be highly appreciated. Thanks in Advance

    Regards
    Amlan Roy

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Could you post a stripped down version of your DB?
    Are you saying that you have a table called map_detail IN your mdb as well as in Oracle?
    Does your SQL return incorrect data for both the linked oracle table as well as for the table that is in your mdb?

  3. #3
    amlanroy is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    May 2012
    Posts
    2
    The Access Version is Access 2003 and Oracle version 11g R2.
    Yes I have map_detail in both oracle and mdb with same table structure. Also if I ran the query select * from map_detail where batch_no="SSO15121". from oracle
    it is giving correct result, but I framed the same query inside mdb and it is providing wrong result.

    Thanks a lot.

  4. #4
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Can you post a very stripped down version of your mdb here?
    You can take out sensitive data first - and only leave the one table with data for SSO15121 and perhaps one other batch_no.
    It would make it easier for me to be able to see first hand what is happening.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access query result in excel format
    By Tha-G in forum Queries
    Replies: 1
    Last Post: 01-06-2012, 01:41 PM
  2. Replies: 1
    Last Post: 12-20-2011, 03:32 PM
  3. Title: Giving Wrong Name
    By netchie in forum Forms
    Replies: 5
    Last Post: 09-15-2011, 10:53 AM
  4. DLookUp function giving invalid use of null error
    By shubhamgandhi in forum Programming
    Replies: 4
    Last Post: 07-21-2011, 06:04 PM
  5. NoData() still giving me an error.
    By cowboy in forum Programming
    Replies: 3
    Last Post: 04-08-2010, 12:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums