Saving Access Queries

[Guest]

I know that Access automatically saves data, regardless if you want the
information to be permanent or not. So, is there any benefit to saving your
queries and databases manually?

 

[Allen Browne]

Access saves the record in the form automatically.

There is one case where it just loses the data without even notifying you
that the save failed. See:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html

There are many other cases where you get very strange problems and error
messages in your code, that can be avoided if you explicitly save the record
before doing something else that will require the record to be saved (such
as applying/removing a filter or a sort, moving record, printing, ...)