Email us at: contact@thesisandcode.com | Phone: 0091-9840890256
thesisandcode logo

Thesis Coding Experts

Instant answers to all your coding queries by thesis coding experts
Home Question And Answer

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.
Was this answer helpful?
Share icon 0 icon 0