Computer Learning Zone

The Simple Microsoft Access SQL Mistake Almost Every Developer Makes At Least Once - QQ 93


Listen Later

In Quick Queries #93, we discuss a common Microsoft Access SQL mistake that can break your queries even when the statement appears correct and walk through why a missing field name in SQL criteria causes unexpected results. We also address questions about opening Access databases in separate memory spaces, quirks in the new Form Zoom feature, usage of API code, issues with inactivity timers and popup forms, split testing YouTube thumbnails, and advice on effective recordset cleanup in VBA. We briefly mention how much API detail you need to understand and upcoming tips for managing multiple open database instances.

...more
View all episodesView all episodes
Download on the App Store

Computer Learning ZoneBy Richard Rost