By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

How to disable a query

code green
Expert 100+
P: 1,726
I have some UPDATE and DELETE queries in an Access database that if I ran at the wrong time it would be a mini disaster. I am scared of opening in 'datasheet view' instead of 'design view' when editing the queries. Is there a simple way to prevent the query running but still allow editing and saving.
May 11 '07 #1
Share this Question
Share on Google+
6 Replies


ADezii
Expert 5K+
P: 8,619
I have some UPDATE and DELETE queries in an Access database that if I ran at the wrong time it would be a mini disaster. I am scared of opening in 'datasheet view' instead of 'design view' when editing the queries. Is there a simple way to prevent the query running but still allow editing and saving.
You could always 'Hide' the Query, and with special keystrokes, make it Visible/Invisible again. It would now not be visible in the Database Window but could still be accessible via code. Let me know if this is what you want.
May 11 '07 #2

code green
Expert 100+
P: 1,726
Not really. I want to have the query open so I can edit it, but temporarily disable it so that i cannot run it. If it is hidden i will forget about it being there
May 11 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Not really. I want to have the query open so I can edit it, but temporarily disable it so that i cannot run it. If it is hidden i will forget about it being there
In tools - options under the Edit/Find tab. There is a list of checkboxes with the heading Confirm. Make sure all three are checked. This means access will pop up a prompt window asking for confirmation of any update or delete query.

Mary
May 12 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
In tools - options under the Edit/Find tab. There is a list of checkboxes with the heading Confirm. Make sure all three are checked. This means access will pop up a prompt window asking for confirmation of any update or delete query.

Mary
One further thing to remember, these settings are access specific and not database specific so if you move applications you will have to check the settings again.
May 12 '07 #5

JConsulting
Expert 100+
P: 603
I have some UPDATE and DELETE queries in an Access database that if I ran at the wrong time it would be a mini disaster. I am scared of opening in 'datasheet view' instead of 'design view' when editing the queries. Is there a simple way to prevent the query running but still allow editing and saving.

Alternatively...

Create a table with 3 columns to store the name and type and SQL of your query. you can then use them with a minimal amount of effort to either cut and paste, or create a query definition using the table contents.

Just a thought.
J
May 12 '07 #6

code green
Expert 100+
P: 1,726
Thanks for these tips. I will implement these ideas today.
May 14 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.