1

I was testing this today, I opened the main database window in my Access 2003 database, clicked the Queries tab in the list of objects, selected Query1 and pressed the delete key. It just disappeared. No "Are you sure you want to delete this query?", it was just gone.

The side bar I was talking about with a query selected...and then you just press delete and it's gone!

Is there some way of making a prompt appear in this scenario?

leeand00
  • 21,508
  • 43
  • 120
  • 182
  • Better? I had a long useless rant which must have contained the specifics of how the query was deleted, and removed that from the text. – leeand00 Apr 07 '15 at 20:34
  • 1
    Knowing what's ACTUALLY going on helps formulate useful answers. ;) So, to clarify, you're just clicking the query tab itself, and then hitting delete, and it closes the tab without a prompt, even if the query is un-saved? Can you provide a screenshot, so we all know that we're talking about the same Query tab? :) – Ƭᴇcʜιᴇ007 Apr 07 '15 at 20:38
  • No, it was an existing query. And I clicked it and hit delete. Well okay so it's not a tab, it's more like a side-tab, or a side-bar? It says objects at the top. MS Access doesn't look like this now-ah-days. – leeand00 Apr 07 '15 at 20:47
  • okay...here it is...I took a screenshot. – leeand00 Apr 07 '15 at 20:53

1 Answers1

1

You can adjust this from the menu at:

Tools | Options... | Edit/Find | Confirm | Document deletions

(But also scripts can change it automatically when you run forms or reports. Sometimes they can change it without you knowing it has been changed. ... Like when they change it, then abort with an error, before they change it back to what it was.)

Elliptical view
  • 1,160
  • 12
  • 23
  • 1
    Ah so the code can turn it off. That explains it. A quick fix would be to turn it back on when it errors out. – leeand00 Apr 16 '15 at 01:40