The FieldAttributesEnum defines the AutoIncrement as Attributes= 16 the

Type = 4

Just check for the two combinations
 

  "Neale, Chris" <chris.neale@t...> wrote: 

Sure. Using an ADO OpenSchema check if the column property ISAUTOINCREMENT
is true. If it is true then you've got an Autonumber. This also works for
SQL Servers INT INDENTITY data.

Alternatively, if you're using ADOX, check the 'Autoincrement' property of
the item in columns collection within the recordset object. (Somewhat Win2K,
Access2k, SQLServer2k only though.. ADOX is cool if you have it available.)

Chris