Displaying fields(columns) in MS Access

[David P. Jessup]

Good day to everyone.

I have found using various connection types my table display comes up
differently.

If I use an OLEDB type connections my columns are sorted alphanumeric.

If I use an ODBC type connections my columns are sorted based on how they
appear in the actual table.

Is there a way to always have the columns displayed in the order they are
listed in the actual table without using an ODBC provider?

Code:

Set rs=server.createobject("adodb.recordset")
rs.open pTable, pConn
'pTable is variable of table name
'pConn is connection string

for each fld in rs.fields
response.write fld.name
next

end Code:

[Aaron Bertrand - MVP]

> Is there a way to always have the columns displayed in the order they are

> listed in the actual table without using an ODBC provider?

Yes, use a SELECT statement, and *list* the columns. SELECT *, or rs.open
tablename (which is the same thing), should not be used in production
code... [url]http://www.aspfaq.com/2096[/url]

There are often far better options for getting schema than extracting it
from an expensive query of all the data... [url]http://www.aspfaq.com/2177[/url]