Question About ADOX.Catalog

M

MDW

Hey all

I'm trying to display a list of all the columns in a table using the ADOX Catalog. Here's the code I have

Set objConn = CurrentProject.Connectio
Set objCat = CreateObject("ADOX.Catalog"

objCat.ActiveConnection = objCon
Set objTbl = objCat.Tables(WhichTable

For Each objCol In objTbl.Column

strList = strList & ";" & objCol.Nam

Nex

WhichTable is a variable containing the name of the table I'm interested in

Now, this code WORKS, but the columns are added to the list in alpha order, instead of the order they are defined in the table itself. Is there any way to return the columns in the order that they appear in the table

Access 2000/Win2k
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with ADOX.Catalog 2
Accessing Closed Workbook Information 1
Application autolinking to 3 database back-ends? 0
Auto-Linking to multiple Database Back-Ends 0
ADOX new table availability in Access 0
Automation of normalization 2
Three questions about sending an email with Access and Outlook 200 1
Requery of Listbox does not display new data 0

Top