ASP Access Autonumber property

[mike]

Hi, I am wondering if there is a way to retrieve wether a given column
in an Access Database is an autonumber as opposed to just an integer.
Currently I am just retreiving all of the columns from a table in a
recordset, and am able to determine the datatype of all of the
columns. Here is my example code.

Set rsExample = cnnConnection.EXECUTE("SELECT * FROM Table")

For Each cmnColumn in rsExample.Fields
if(cmnColumn.TYPE = 3) then
'This is a numeric field
'Here I would like to determine if this column is an
autonumber as opposed to a number. Both have TYPE = 3
else
'This field is non-numeric
end if
Next

Both AutoNumbers and Number return a type = 3. Is there another way
to accomplish this?

Mike Biang
Web Applications Developer
Cramer Development

[Aaron [SQL Server MVP]]

There is an IsAutoIncrement property. I just updated the last sample at
[url]http://www.aspfaq.com/2177[/url] and it might help.

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"mike" <mbiang@rockisu.com> wrote in message
news:8d00393f.0408110914.1c54b38b@posting.google.c om...

> Hi, I am wondering if there is a way to retrieve wether a given column
> in an Access Database is an autonumber as opposed to just an integer.
> Currently I am just retreiving all of the columns from a table in a
> recordset, and am able to determine the datatype of all of the
> columns. Here is my example code.
>
> Set rsExample = cnnConnection.EXECUTE("SELECT * FROM Table")
>
> For Each cmnColumn in rsExample.Fields
> if(cmnColumn.TYPE = 3) then
> 'This is a numeric field
> 'Here I would like to determine if this column is an
> autonumber as opposed to a number. Both have TYPE = 3
> else
> 'This field is non-numeric
> end if
> Next
>
> Both AutoNumbers and Number return a type = 3. Is there another way
> to accomplish this?
>
> Mike Biang
> Web Applications Developer
> Cramer Development