[AccessD] Walk the DB Using ADO

Arthur Fuller fuller.artful at gmail.com
Sat Jul 2 12:06:08 CDT 2011


I know that I've written this code before, but due to a plethora of backup
CDs and my habit of pruning what is not currently necessary from the current
situation(s), I can't find the relevant code. And besides, I'm currently
semi-retired, and working in hobbyist most not billable mode.

Here's what I need, in ADO format if possible:

<pseudo vba>
For each t in CurrentDB( Tables )
    For each f in t.fields
        For each a in f.Attributes    ' could be Properties not Attributes
            Debug.Print a.Name, a.Value
       Next
    Next
Next
</pseudo vba>

TIA,
Arthur

P.S.
For years and years and years, I have used Rick Fisher's FindAndReplace, but
now it's failing on me due to (I think) the fact that I'm running a 64-bit
Windows, which doesn't like what he offers to install. In my retirement
mode, I cannot afford to purchase more software. Maybe I could run a Windows
32-bit version of everything, then run F&R, then do what I need to do, then
import the results back into 64-bit. Yuck.



More information about the AccessD mailing list