Re: select or update ordinal

is there any way I can select or update a field by specifiying the ordianl
instead of the column name?

Sure. But if you mean, given the name can you work out what he ordinal value
is => no, AFAIK.

If you have

SELECT field1,field2,field3 FROM mytable

for a recordset

then you can use

Fields(0)

instead of

Fields("field1")

and the former is faster.

Stephen Howe





.