Arthur Fuller
fuller.artful at gmail.com
Tue Jul 5 17:05:23 CDT 2011
I would most appreciate your Send! Thx, A. On Tue, Jul 5, 2011 at 5:18 PM, Fred Hooper <fahooper at gmail.com> wrote: > Hi Arthur, > > As I work with new databases frequently, I've found it useful to create an > Access db that uses ADO to get information on the owners, tables and views > -- and place it in an Access table. It currently works for Oracle and SQL > Server. > > I'm happy to send a copy if it would be helpful. > > Fred Hooper > > > On 7/5/2011 3:57 PM, Arthur Fuller wrote: > >> 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 >>> >>> >>> -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> > Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >