Arthur Fuller
fuller.artful at gmail.com
Tue Jul 5 14:57:57 CDT 2011
Thanks, Drew. I'll give that a shot. It's been a while since I looked carefully at the ADO model for other than typical recordset operations.. I seem to recall that somewhere I have a diagram of it, and even a DAO->ADO conversion chart. Time to start perusing the documents directories. A. On Tue, Jul 5, 2011 at 2:45 PM, Drew Wutka <DWUTKA at marlow.com> wrote: > Sorry I don't have this code exactly as you have here. But what you > need to do is actually all in recordsets. > > You use a SCHEMA query to get the list of tables (you can get columns > this way if you want, too). And then you use properties of the field to > get other values (like field name, value, constraints, etc). > > Drew > >