[AccessD] Create Table Autonumber Field

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 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com