[AccessD] ADO - Getting a Tables columns back in physical order

Drawbridge.Jack at ic.gc.ca Drawbridge.Jack at ic.gc.ca
Wed Jan 26 15:19:47 CST 2005


 I'm sure someone has a solution to this.

I have A2K and am using ADOX to retrieve the structures of existing tables.

When I use this type of approach

Dim cat As New ADOX.Catalog
Dim tbl As ADOX.Table
Dim col As ADOX.Column
cat.ActiveConnection = CurrentProject.Connection

 for each tbl in cat.Tables
  If tbl.name = "Table I'm Looking For"  then 
      for each col in tbl.Columns
         debug.print col.name
      next col
  endif
 next tbl

 I get the column names, but in ascending name order. How do I get the
Column Names in the physical order in the table???  Does someone have
sample code?

TIA

jack



More information about the AccessD mailing list