Results 1 to 2 of 2

Thread: [RESOLVED] [Access 2003] Query that doesnt run right

  1. #1

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Resolved [RESOLVED] [Access 2003] Query that doesnt run right

    Hi

    In Access 2003 I have a query. Its been running fine until last month, where it refuses to run (executed from Excel).

    I have found out that its erroring stating that there are records already existing with the primary key. Fair enough. Except the wuery has been written to exclude those that have the primary key.

    So it looks like Access is ignoring the filter condition and running the lot or is not retrieving data correctly.

    Has anyone else had this recently (perhaps an MS Office update to break 2003 and request 2007 upgrade??) ?

    I am going to look further into it, but the second query erases the data in question, so tonight I shall have another look.



    ---

    Could it be that there are duplicate records in the main table, that dont exist in the second table, but do after it adds the first record?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  2. #2

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: [Access 2003] Query that doesnt run right

    Dont worry about it, its duplicates adding from the main list - fixed now

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Click Here to Expand Forum to Full Width