VB access to tables collection

  • Thread starter Thread starter Bruce Beitman
  • Start date Start date
B

Bruce Beitman

How do I programmatically view the tables collection to
determine the fields in the table? I have been able to
view the tables collection using the AccessObject and the
alltables. What happened to the documentation?
 
Bruce said:
How do I programmatically view the tables collection to
determine the fields in the table? I have been able to
view the tables collection using the AccessObject and the
alltables. What happened to the documentation?
Click to expand...

It sounds like you're using Jet tables with ADO in a VB
program, if so, I have no idea.

If you're using VBA in Access with Jet tables, then you
should be using DAO. In this case, Use the TableDefs
collection to "view" the tables and then use a TableDef's
Fields collection to "view" the fields in the table.
 
Back
Top