Thesis Coding Experts

Question Answer

Posted Time & Date | 11:39 AM - 28 January 2017

Ques :
How can I speed up Access 2007 database?

Answer :
Close forms containing unbound OLE Objects if not in use. When unbound OLE objects activated, the memory used in that operation is not released until the form is closed. Also, form's load time is reduced when its code is moved to a standard module from the form module. The form's module doesn't always need to be loaded whenever form loads. However, the standard module has to be loaded at some point, but it stays memorized once it is loaded until you close the database. However, the standard module has to be loaded at some point, but once it is loaded it stays in memory until you close the database.