FMS Facebook Page
Jump: Search:

Free Resources from FMS

Additional Resources

 

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

 

Free Catalog

 

 

Use the Requery method instead of the Requery action

Provided by: Total Access Analyzer

Use the Requery method instead of the Requery action. The method is significantly faster than the action.

 When you use the Requery action, Microsoft Access closes the query and reloads it from the database. When you use the Requery method, Microsoft Access reruns the query without closing and reloading it.

 See http://msdn2.microsoft.com/en-us/library/aa221575.aspx for more information.

This tip and more detected by Total Access Analyzer!  Find out more!

 

Return to the tips page


 
Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © FMS, Inc., Vienna, Virginia
Celebrating our 26th Year of Software Excellence