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.
Is there some way of making a prompt appear in this scenario?
leeand00
Posted 2015-04-07T20:20:38.040
Reputation: 14 882
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
Posted 2015-04-07T20:20:38.040
Reputation: 864
1Ah 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 – 2015-04-16T01:40:03.833
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 – 2015-04-07T20:34:39.317
1Knowing 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 – 2015-04-07T20:38:04.730
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 – 2015-04-07T20:47:40.363
okay...here it is...I took a screenshot. – leeand00 – 2015-04-07T20:53:40.137