You don't loop through the tables, per se. You loop through the recordset. So once your recordset has been retrieved, you typically loop through it with a Do...Loop (since you won't necessarily know before hand how many records have been retrieved).
But you *can* loop through all of the tables in an mdb via DAO, and return their props, etc. Just wondering if this is possible via ADO. Haven't been able to find anything on it, so I doubt it. Pity.
<BR>> Haven't been able to find anything on it,...<BR><BR>Guess you didn't look here in the MS docs? <BR><BR>http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/dasdk/mdam2ppd.htm