Does anyone know of a way (via ADO or ADOX), besides using the
connection's schema, to find the ordinal position of a field?
Right now, I'm looping through every record of the recordset created
by the OpenSchema(adSchemaColumns) method of a connection, dumping the
ORDINAL_POSITION field into an array, and it's not working out very well...
I looked through the properties of an ADOX catalog, but didnt
find anything there... The Database I'm using is in Jet/Access...
Any help would be greatly appreciated..
Thanks,
--Doug