Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Cannot close query w/o saving (2003)

    I recently developed a strange behaviour in Access. If I write an ad hoc query and want to just close it without saving, I cannot. All I get is the dialog box with Query1 in the name and OK/Cancel. IF I do cancel I just go back to the QBE grid.
    Any ideas?
    Thanks
    Zave

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

    Re: Cannot close query w/o saving (2003)

    Does this happen in all databases or just in a specific one?

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cannot close query w/o saving (2003)

    one specific one

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

    Re: Cannot close query w/o saving (2003)

    First, see if Tools | Database Utilities | Compact and Repair Database helps.
    If not, create a blank new database and import all database objects from the problem database into it. You'll have to set startup options (if any, in Tools | Startup), and non-standard references (in Tools | References in the Visual Basic Editor) as in the original database. Hopefully, the problem won't occur in the new database.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cannot close query w/o saving (2003)

    I have compact set on close anyways, so this did not work. Will have to recreate as you said.
    Is this a known "upgrade opportunity" AKA bug? (I really want 2007)

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

    Re: Cannot close query w/o saving (2003)

    > Is this a known "upgrade opportunity" AKA bug?

    Not really <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    These things just happen... No doubt they'll happen in Access 2007 too

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Cannot close query w/o saving (2003)

    Just for your info I encountered exactly the same problem the other day. I was visiting a client, and constructing some ad hoc queries in an exisiting database that otherwise works OK.
    All I could do was save the queries then delete them.
    Regards
    John



Posting Permissions

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