Saving Access Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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, ...)
 
Back
Top