Access icon

List all MS Access queries in database

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 »

Access icon

Updated Access VBA code to delete empty records

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