Query Run

  • Thread starter Thread starter Douglas
  • Start date Start date
D

Douglas

When running a query, what is the difference in using the RUN to run your
query or using the view icon (first icon on the left side of the toolbar)?
 
For a simple SELECT query, there is no difference. There is a difference if
you are using an Action query (insert, update, delete, or make table).

Clicking on the View datasheet button, will show you the records that would
be affected (but it doesn't actually run the query). Clicking on the Run
button will actually run the action query and make the changes.
 
Back
Top