[AccessD] Create Table Autonumber Field

Excellent - Thanks.

At 21/09/2005, you wrote:
>David,
>Here is the pointer to MS's suggestion for how to do it in Access97
>http://support.microsoft.com/kb/q113546/
>
>regards
>borge
>goldcoast, australia
>(back again after dropping off the list in may due to travel)
>
>
>----- Original Message -----
>From: "David Emerson" <newsgrps at dalyn.co.nz>
>To: <accessd at databaseadvisors.com>
>Sent: Wednesday, September 21, 2005 2:17 PM
>Subject: [AccessD] Create Table Autonumber Field
>
>
> > Access 97 DAO
> >
> > I am creating a table using DAO.  How do I create an autonumber
> > field?  My current line is:
> >
> >      Set fld = tbldef.CreateField("NetExpAllowanceID", dbLong)
> >
> > This of course only creates a number datatype.  I can't see in the
> > help the constant for an autonumber data type.
> >
> >
> > Regards
> >
> > David Emerson
> > Dalyn Software Ltd
> > 999 Moonshine Rd, RD 1
> > Judgeford, Porirua
> > New Zealand 6006
> > Phone    0064 4 235-6782
> > Fax      0064 4 235-6783