473,396 Members | 1,998 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to disable a query

code green
1,726 Expert 1GB
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
6 3965
ADezii
8,834 Expert 8TB
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
1,726 Expert 1GB
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
14,534 Expert Mod 8TB
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
14,534 Expert Mod 8TB
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
603 Expert 512MB
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
1,726 Expert 1GB
Thanks for these tips. I will implement these ideas today.
May 14 '07 #7

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

Similar topics

4
by: Pecos Bill | last post by:
Salve, non riesco a disabilitare un trigger su sqlserver nè da query analyzer, nè da enterprise manager. In pratica tal cosa riuscivo a farla in Oracle con TOAD, mentre qui non riesco. Mi...
32
by: Mark Johnson | last post by:
You have an, a, anchor with href link. Can you use a stylesheet to effectively disable the link, so that you can't click on it; that it will appear simply as text?
8
by: Matt | last post by:
Hi everyone I was wondering if there was a way to disable a single database with having to shutdown mysql or rename tables? Thanks, Matt
2
by: StaZ | last post by:
Hello, I would simply like to know if there's a way to disable the "feature" of MS Access that rewrites your queries "correctly"... This feature makes this : ...WHERE SomeBooleanField...;...
1
by: Matthew | last post by:
I have a form with fields that act as user specified criteria for a form. Two of the fields are start and finish date. The fields in my query are "ID", "TimeStart", "TimeEnd", etc. Currently, I...
9
by: junlia | last post by:
Does anyone how how can we disable the auto-postback feature in asp.net page? I have to use a server side control in the page, but the auto post back feature in it causes problems for me. Please...
1
by: Philip Bondi | last post by:
Hello to all SQL Server junkies who work with non-English characters: For people running scripts from the command line using ANSI files with special characters, it is very important to use isql...
11
by: Joey | last post by:
Hello, In my C# asp.net 2.0 application, I have a webform with a button server control on it. The webform, like most others in the site, subscribes to a master page. I have determined that the...
3
by: voroojak | last post by:
hi I have a such abig problem. i have to disable the shortcut keys (table, query, report, .....) except form. the user should just be able to open form and all other the shortcut should be disable....
1
by: David Henderson | last post by:
I know 'disable-output-escaping' has been discussed in the past, but I can't put my finger on any of the threads to see if my current problem is addressed. Sorry for re-asking the question if it...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.