Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jun 2003
    Location
    Washington, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupted Query (Access 2k)

    I currently have a Union Query that runs correctly, however, whenever, I try to open the query in design view, weird things begin to happen. I mean my toolbar, menu bar and short cut menus become deactivated. After closing of the query this phenomenon continues. My only solution is to closes the database and close Access completely. Upon reopening of the database if functions correctly, unitl I attempt to modify the query in question.

    Has anyone else experienced this problem and if so what should I do to solve this problem.

    Thanks,

    Karen

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Corrupted Query (Access 2k)

    Never seen this, but...
    1. Make a copy of the database, to be on the safe side.
    2. Perform a compact and repair (Tools | Database Utilities...)
    3. If that doesn't help, try to import everything (tables, queries, forms, ...) into a new blank database.
    4. If you have a recent backup of the database, you can see if that shows the same behavior.
    5. You can try to reconstruct the union query from scratch.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Corrupted Query (Access 2k)

    A Union query can only be displayed in SQL view - the query designer doesn't work for those kind of queries. Is that where things are going funny? It may be that you have some corruption in your database - you might try importing all of the objects into a new database and see if that results in normal behavior. If not, try copying the SQL string for the Union query into a different database with just links to the appropriate tables and see if you still have the same behavior.
    Wendell

  4. #4
    Lounger
    Join Date
    Jun 2003
    Location
    Washington, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupted Query (Access 2k)

    Thanks for the suggestions, I have tried everything you suggested and the problem still exists. Any other ideas?

    Karen

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Corrupted Query (Access 2k)

    If none of the steps work, the query is most probably corrupted beyond repair. You have two options (points 4 and 5 of my previous reply):
    - Retrieve a copy of the query from a non-corrupt backup (provided you have one, of course)
    - Reconstruct the query from scratch.

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Corrupted Query (Access 2k)

    I'm afraid Hans has covered all the options - <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>
    Wendell

Posting Permissions

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