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
  • 23,552

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,330