Look carefully at the output. All of the tables and views are listed in the column TABLE_NAME. You may be looking at the TABLE_QUALIFIER column.

I'm not found of such a slow method either. But he asked!

That should've worked, I tested it before I sent it. Make sure your recordset has data in it. You can test this by inserting a msgbox rst.count somewhere after you...

'Paste all of this into a new module in MS Access. Most of the added code comes from 'The Access Web, but I added some steps and variables here to...

I'm reposting because my first one didn't take.

Unless you want to be able to call this functionality from within a MS Access application (such as with the click of...

Are there any null values in your Access date columns? This will do it. If so, try updating the null dates to some arbitrary date first, then retry. I had this...