In Quick Queries #89, we address troubleshooting the ODBC insert error with linked SQL Server tables in Microsoft Access, especially involving long text fields and the recent Office Build 2604 bug. We discuss practical workarounds, differences between chained and nested queries, common issues with copy and paste in Access, using and adapting web APIs when services change, and adjusting list box column widths. We also touch on database storage best practices, working with abstraction layers in programming, compatibility between 32-bit and 64-bit Access versions, and answer several viewer questions on related Access development topics.
Popular Podcasts
Dateline NBC
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com
The Breakfast Club
The World's Most Dangerous Morning Show, The Breakfast Club, With DJ Envy, Jess Hilarious, And Charlamagne Tha God!
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.