Faster Access Databases Performance Tips

Faster Access Databases Performance Tips

Every developer has their own coding style. Like some devs prefer to use docmd.RunSQL code, while others prefer to use DB. Execute code. When I'm researching best practices and procedures to be added into our VBA library collection, I stumbled upon a great paper explaining Tips to Speed up Microsoft Access Databases Performance. This paper is honorably featured on Microsoft MSDN and contained 100+ tips for faster Microsoft Access Databases, including:

• Table Performance Tips

• Linked Databases and Linked Tables

• SQL Server and ODBC Performance Tips

• Database Performance Tips

• Query Performance Tips

• Form Performance Tips

• Report Performance Tips

• Macros Tips

• Access Module/VBA Performance Tips

• Data Access Objects (DAO) Programming Tips

• Jet Engine Tuning Tips

• Access Startup Tips

• Multiuser Performance Tips

• Computer Performance Tips

• Windows Performance Tips

• Conclusion

• Additional Resources from Microsoft

You can access the paper on FMS, inc site. Kudos for Luke Chung, President of FMS, and Dan Haught, Executive Vice President.