The site formerly known as Code For Excel and Outlook
July 22, 2011 by · 
In my quest to optimize my Access queries, I wanted to view the underlying SQL for each query. However I have dozens of queries and manually examining each one is a hardship. Here's how I did it with VBA.
Continue Reading: List all MS Access queries in database »
January 13, 2010 by · I recently had to use the code I posted in Clean and Repair Your Access Database to delete blank records from a database. But it failed because one of the tables has spaces in the name. I didn't create the table, I swear!
Continue Reading: Updated Access VBA code to delete empty records »
Site last updated: February 8, 2012
Follow Me