Tools Hiding Shortcuts in Everything Here's a quick tip from Tom Wickerath for hiding shortcut files from your Everything file search results.
Tools vbWatchdog Webinar Peter Cole of ThemeMyDatabase.co.uk presents a demonstration of vbWatchdog in action. Come for the info, stay for the discount code.
Tools Bad Words in Access Note, Caption, Format, Pages, Sequence. All reasonable-sounding field names, but all should be avoided.
Tools Installing and Updating Access Applications Want to be a professional Access developer? Then you can't ask your clients to copy and paste .accdb files to their computers. What do you do instead?
Tools 21st Century Visual Basic Microsoft stopped supporting VB6 in 2008. Here are some modern options for migrating those old apps or developing new ones in 2020 and beyond.
Intermediate VBA Code Generation Trick Using Notepad++ to transform existing code into a VBA string that generates itself.
Advanced JetShowPlan: A Primer You may be familiar with JetShowPlan, but I guarantee you've never read an article about it quite like this one.
SQL Server Tuning Access Query Performance The four best tools/techniques for tuning Access query performance: JetShowPlan, Process Monitor, TraceSQLMode, and SQL Profiler.
SQL Server All Hail Ola! If you're managing SQL Server and you're not using Ola Hallengren's scripts, then you're doing it wrong.
Tools My Favorite Things Here is a list of my favorite utilities, add-ins, OCX controls, and applications that I use when developing Microsoft Access applications.