www.CalvinSmithSoftware.com

1. Did you know that the RunSQL command in MS Access, actually processes tasks on the disk, which is much slower than memory? Imagine the performance degradation on large data sets. Not good for your end-users! A temporary QueryDef would be much faster as demonstrated in this MSDN link.

2. Did you know that embedded SQL has to be recompiled, unlike a stored query? That can be slow! Not good for your end-users! This MSDN link suggest to use stored queries instead of embedded SQL for better performance.

3. Did you know that bound forms are much slower than unbound forms? Imagine a user waiting for thousands of records to be loaded before a form opens! Not good for your end-users! Provide your user with a criteria interface that allows filtering of large data sets.