Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Arizona, USA

    Unanswered: Heads-Up: Access 2007 Bug

    Just wanted to post a warning. I spent an unpleasant 45 minutes yesterday. I had a complex "one-of" data export to text that I was working on (with a tight deadline,) so I had linked to a SQL Server table, & built a query which concatenated/formatted the data the way I needed it, with a fixed value defined in the selection criteria for one of the fields in the table. I ran the query, and exported the resultset to a text file.

    Then, incremented the fixed value, ran the query, and saved that result set to a text file. And did so 4 more times, for a total of 6 text files. All was well...sort of. When I took a close look at the resulting text files, the data was identical in all 6 of them! After some experimentation, it turns out that the export to text wizard DOESN'T use the active result set (as it should) for the export at all! It apparently loads the query from the saved version, and runs THAT ?@(*%#)*&#@$

    The workaround is to save the query after each change to the select criteria...
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    Sounds like a bug to me Lou. I do recall though when I edited a query with new criteria, etc..I always had to re-Save the edited query first before exporting otherwise it didn't seem to take (I think this happens on pre-2007 versions as well.)
    Last edited by pkstormy; 02-28-09 at 23:15.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    How stupid is that

    Thanks for the info!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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