Preferred Method to Running Queries - Datasheet View or Exclamation Mark (Run)

[abc]

I was told from a colleague of mine to run queries using the datasheet
view on the toolbar rather than the exclamation mark (run) on the
toolbar.

He said to only use the exclamation mark when running an action
query.....

What is the correct method to running queries and why??

Thanks for any help!

 

[Guest]

I give somewhat the opposite advice. I alway use the Run button for queries.
The exception is before running some action queries I'll first go to
datasheet view. This shows the records about to be acted upon. That way I can
do a quick check to see if I'm going to modify the correct records. If I like
what I see, I'll then run the action query.

 

[Arvin Meyer [MVP]]

There is no difference in Select queries. On Action queries only, the
datasheet view, is a Select query, while the Exclamation point is the Run
button to run the query. I always use the Exclamation point except when I
need to look at the data that an Action query will be acting upon.

I am unaware of any "correct" method. They both work fine.