Total Access Analyzer 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.

For more information, visit Microsoft's page Requery Method [Access 2003 VBA Language Refernce]

This tip and more can be detected by Total Access Analyzer! Try the free trial download of Total Access Analyzer today!

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.


View all FMS products for Microsoft Access All Our Microsoft Access Products

 

 

Free Product Catalog from FMS